anything in Excel...

It's Excel-o-lozy...

vLookup - Value Not In First Column... Solution...

www.Excelolozy.com - Ever thought of any solution to the problem where vLookup should search the value in any column rather than first column.

Formula vLookup has a problem that it searches the value in First column only and gives value from any column you need the result from.

Solution is there...

avLookUp() which means "AllSideLookup"... ;)

Click here for solution to vLookup Limitations.
 
 

Anything in Excel, be an Excelolozian...

for best MS Excel Tips visit http://www.Excelolozy.com

gotta query??? drop a mail at mail@excelolozy.com