MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Using lookup and selecting adjacent cell


Posted by CAsey on February 08, 2002 6:32 AM

Hello,
Im trying to find a way to use the lookup function for a number and then select the cell from the column immediatly to the right of it. Is this possible?
thanks
Casey


Posted by Chris D on February 08, 2002 12:17 PM

that's exactly how VLOOKUP works...... check out the help file for the EXACT syntax

:-)