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

--

Dave Peterson