| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlook up w- multiple variables
For my vlook up in excel 2007, I want to return data to populate cell B2
(xxxx) from column 3 ($21,745) of a data set when the value in cell A2 (360 19318) AND B1 (200801) match from the original data set. DATA SET 1 2 3 Dosfrom OP_Combined Claimed_Avg 200801 360 19318 $21,745 200803 360 19318 $22,462 200805 360 19318 $25,527 200806 360 19318 $22,462 A B c D 1 Row Labels 200801 200802 200803 2 360 19318 xxxx 3 360 47562 4 480 93620 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| look up by multiple variables | Excel Discussion (Misc queries) | |||
| VLOOK ups accross Multiple Tabs | New Users to Excel | |||
| VLOOK-pivot table expanding want to update vlook automatically | Excel Worksheet Functions | |||
| VLOOK-pivot table expanding want to update vlook automatically | Excel Worksheet Functions | |||
| HELP ON THE VLOOK UP FUNCTION FOR MULTIPLE VALUES. | Excel Discussion (Misc queries) | |||
Threaded Mode
