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
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