And you can, in fact, use cell references. Array enter into a 2-cell
column, e.g.:

=VLOOKUP((A2:A3),B5:C10,2,FALSE)

Alan Beban

Alan Beban wrote:
If you use values rather than cell references, something like the
following, array entered into a 2-cell row, will return the sought results:

=VLOOKUP({"ok1","ok2"},B5:C10,2,FALSE)

or =VLOOKUP({"ok1";"ok2"},B5:C10,2,FALSE) array entered into a 2-cell
column.

Alan Beban

Dave Peterson wrote:

I like this syntax:

=index(othersheet!$c$1:$c$10,
match(1,(a2=othersheet!$a$1:$a$100)*(b2=othersheet !$b$1:$b$100),0))



Mostafa wrote:

Hi
I know the Vlookup formula
=VLOOKUP(A2,B5:C10,2,FALSE)
Can we change the lookup value ( A2 )
To two cells
Thanks