I want to create one VLOOKUP for a column of cells. How could I go about this? Thanks, Scott
S scott Apr 28, 2006 #1 I want to create one VLOOKUP for a column of cells. How could I go about this? Thanks, Scott
D Debra Dalgleish Apr 29, 2006 #2 You can use an absolute reference, or name, for the lookup table, and a relative reference for the cell in the active row. For example: =VLOOKUP(G3,$B$2:$D$21,3,FALSE) or =VLOOKUP(G3,MyTable,3,FALSE)
You can use an absolute reference, or name, for the lookup table, and a relative reference for the cell in the active row. For example: =VLOOKUP(G3,$B$2:$D$21,3,FALSE) or =VLOOKUP(G3,MyTable,3,FALSE)
