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

:-)