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

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?

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