| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup & 2 variables
Is it possible to use vlookup for 2 criteria? I want to go to another tab in
my workbook and lookup the value that meets 2 criteria. in the example below, I need the id# and project id # to match values on the other tab and return the $ value that matches both. ID # Project ID Amount 123 0523 $1,000 456 0645 $2,000 789 0752 $4,000 028 0523 $5,000 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup with multiple variables | Excel Worksheet Functions | |||
| VLOOKUP - TWO Variables | Excel Discussion (Misc queries) | |||
| VLOOKUP - Two Variables | Excel Discussion (Misc queries) | |||
| using VLookup with two variables to get results | Excel Discussion (Misc queries) | |||
| vlookup Variables | Excel Worksheet Functions | |||
Threaded Mode
