| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
lookup by column & row
Is there a formula or VBA coding that will allow me to serch a range that has
a criteria for the row and another one by the column? For example I have 2/1 2/2 2/3 ATL 40 45 35 BOS 23 9 0 CVG 4 12 10 I need to search this range above and say I need the number for BOS on 2/2, how could I do this? Any help would be appreciated. thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup looks to the prior column if zero appears in the lookup col | Excel Discussion (Misc queries) | |||
| LookUp Function with Two Column Search Returning One Column Value | Excel Worksheet Functions | |||
| macro column lookup enter data in another column same row | Excel Programming | |||
| lookup text in one column, count in another column | Excel Worksheet Functions | |||
| Calculating totals in a column based on a lookup in another column | Excel Worksheet Functions | |||
Threaded Mode
