Where can I find an example for vlookup with each parameter explained?

[caliray]

This is the general formula for lookup, but what does each value represent for finding a name in a single column of names?

=LOOKUP(A1;D1:D100;F1:F100)

I think I understand that A1 is the value to lookup, but can it be text? I also understand the range to search is D1:D100.
What I don’t understand is what is F1:F100. I see it is called a results vector, but how is it used?
LOOKUP(SearchCriterion; SearchVector; ResultVector)

Why doesn’t anyone, especially the official LibreOffice help files give real world examples?

One last thing. I don’t see VLOOKUP OR HLOOKUP in the list of formulas in Calc anymore. Have they been replaced with a single LOOKUP function?

Thanks for helping to clear up this.

[Lupp]

What is wrong with the help texts (offline help) so far? “Real world” examples occur in the real world of one or another user - an will look very different.

My advice: (1) Read the offline help concerning the MATCH function thoroughly first. (2) make your own next-to real-world-examples to make sure you understood. (3) Continue reading on the INDEX function and assure understanding again based on your examples. (4) Use both these functions now combined to find a value associated with a criterion via indexing (a) criterion matched against one part column and value taken from one part row of equal number of elements (b) in two adjacent columns/rows. (5) Make sure you understood the working of the parameter for sort-order-assurance, in specific that it is you who has to make sure the assurance is not a lie.

If there is something not understandable despite thorough study, come back here with a specific example out of your real world.

Now try using VLOOKUP and you will see that it is a limited simplification to achieve with one function call what you would need MATCH and INDEX for in more general cases.

You may try HLOOKUP now. LOOKUP? As you like. It’s not often of much use, and no, it is not a replacement for anything but rather a somewhat outdated variant kept for compatibility.

[caliray]

This is a detailed explanation of how to use LOOKUP. [link text](Tutorials For OpenOffice - No Computer Experience Tutorial & HLOOKUP|outline)

This is not. link text

Both are available on the internet and I’ve looked at many questions and answers in this ask site. Almost all of them provide no real formula examples. They describe the problem in text and the answers often similarly are in text without formulas with detailed explanations of how they work.

Your answer implies much greater knowledge of CALC than many have, thus the need for detailed questions and answers.

Regardless, your answer is appreciated. I might never have found the first example I cite above without your response.

[Lupp]

(Edited) I don’t seem to understand the your post very well. I still think my advice was not so bad, and if it may look strange in a sense to someone here, this should be due to my poor English.

In short I described the way I myself worked into the field years ago.

[Lupp]

@caliray : Well, I meanwhile spent a few minutes with the tutorial you linked. Congratulations! I didn’t know it yet, but it seem to be a good one. (We often find the bad ones first.) Starting with MATCH / INDEX or preferring a start with VLOOKUP … ? Ok, I chose.