View Single Post
  #3   Report Post  
CLR
 
Posts: n/a
Default

This will look up the sum of A2 and B2 in your existing table
=VLOOKUP(A2+B2,B5:C10,2,FALSE)

A new column must be added to the left side of your table with the
CONCATENATED values you wish to look up, then a CONCATENATED lookup would
be.........
=VLOOKUP(A2&B2,A5:C10,2,FALSE)

Vaya con Dios,
Chuck, CABGx3




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