vlookup

[niladri20052006]

Hi All,

Is it possible to do vlookup with two columns at one time? for example I have two sheets in a file. I have two columns named website ans email ID.

I want to do vlookup with website and then email ID. Is it possible to do it at one time?

Thanks in advance!!

 

[andylawson5]

I generally concatenate the 2 columns then do the lookup on the new column. I believe a similar question to this was answered in the thread below:

http://www.mrexcel.com/forum/showthread.php?t=72389