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.