| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I create a VLOOKUP that pertains to multiple cells?
I want to create one VLOOKUP for a column of cells. How could I go about this?
Thanks, Scott |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I create a VLOOKUP that pertains to multiple cells?
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) scott wrote: I want to create one VLOOKUP for a column of cells. How could I go about this? Thanks, Scott |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| make multiple cells in 1 worksheet equal multiple cells in another | Excel Worksheet Functions | |||
| Can't find formula for largest value in multiple cells | New Users to Excel | |||
| conditional formatting to multiple cells | Excel Worksheet Functions | |||
| how can i ignore blank cells when multiple cells? | Excel Worksheet Functions | |||
| Adding separate accumulators for multiple cells | New Users to Excel | |||
Linear Mode
