| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Lookup formula
Can I do 'n Vlookup and then Hlookup in one formula?
|
|
#2
|
|||
|
|||
|
A B C
1 North South 2 Oil 1.00 2.00 3 Gas 3.00 4.00 4 5 6 7 Gas 8 North 'Answer in Cell A9 below: 9 3.00 <<< Contains formula =INDEX(B2:C3,MATCH(A7,A2:A3,0),MATCH(A8,B1:C1,0)) "Esrei" wrote in message ... Can I do 'n Vlookup and then Hlookup in one formula? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Question... LookUP | Excel Discussion (Misc queries) | |||
| copying LOOKUP formula | Excel Worksheet Functions | |||
| How do I have a formula lookup a sheetname? | Excel Worksheet Functions | |||
| Conversion lookup formula | Excel Worksheet Functions | |||
| double lookup, nest, or macro? | Excel Worksheet Functions | |||
Linear Mode
