View Single Post
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default

I have done this a few times. In my lookup table, I create a 3rd column,
where I put =A1&B1. This strings 2 values together.
Then you can do a vlookup for A2&B2.
*******************
~Anne Troy

www.OfficeArticles.com


"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