| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
is it possible ot use two or more columns as criteria in VLOOKUP?
I need to be able to use two colums (State (B2:C####), County(C2:C####)) to
match against corresponding columns 2 and 3 in a VLOOKUP (named FIPS_LOOKUP) table and return data stored in Column 4 to WORKSHEET1!A2. The idea is that a user will populate WORKSHEET1!Col B and C and the formula pasted in Col a will return a value. The number of rows populated will fluctuate widely, so I wul like to figure out how to hav eth formula run for only the number of rows populated in Columns B and C. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| get a total based on criteria in two columns | Excel Worksheet Functions | |||
| Totaling criteria from 2 columns | Excel Worksheet Functions | |||
| Vlookup with 2 columns | Excel Discussion (Misc queries) | |||
| Sumproduct with a vLookup, multiple criteria | Excel Worksheet Functions | |||
| vlookup for multiple columns | Excel Worksheet Functions | |||
Threaded Mode
