| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup formula for both row and column
I am trying to do a lookup on both row and column. My spreadsheet has
targets per cost center (Rows) by Months (Columns) starting in Column D. The "Row" lookup is working but how do I add the second portion. See ???? below This is the formula I have so far: =VLOOKUP($A3,TLTargets!$A$46:$Q$86,????,FALSE) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Double column lookup formula Help | Excel Worksheet Functions | |||
| LookUp Function with Two Column Search Returning One Column Value | Excel Worksheet Functions | |||
| LOOKUP FORMULA INTERSECTION OF A COLUMN AND (TWO) VALUES IN A ROW | Excel Worksheet Functions | |||
| Formula to lookup Multiple Column Text and then Count Result | Excel Worksheet Functions | |||
| Calculating totals in a column based on a lookup in another column | Excel Worksheet Functions | |||
Threaded Mode
