How do I return a column value based on whether another column is within an array range - Libreoffice Calc

worksheet-function libreoffice spreadsheet

VLOOKUP will not work as the lookup column is right of the return column. Use INDEX/MATCH:

=INDEX(A!A:A,MATCH(A1,A!B:B))

enter image description here

Related

find files with ACLs set
Why can't I type text above a table?
How to solve Half Duplex/Full Duplex issue
what's the difference between "important to" and "important for"?
Is there a phrase, word or saying when one 'has the thought or feeling of causing hurt of mischief" despite never dreaming of acting on it?
"It is good for me." or "It is good to me." [closed]
Does "narrowly avoiding" something always imply an action was taken?
What do you call a person that is consistent in her beliefs despite the difficulties they might cause?
difference Criterion vs Criterium [closed]
On THE other hand or on another hand?
Why do we use "benign" instead of "benignant" in medicine?
What is the difference between “Special Counsel” and “Special Prosecutor”? Are they same after all?