| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Stumped by a lookup scenario
I'm trying to LOOKUP value #1 in one cell, then LOOKUP value #2 in a
second cell. Based on the result of those 2 LOOKUP's, I want the furmola to return the correct value from the intersection of the LOOKUP results in a table of data. I'm stumped...is this possible? Thanks in advance... :D |
|
#2
|
|||
|
|||
|
Data list = A1 to E25
Value to find in Column A is entered in F1 Value to find in Row1 is entered in F2 =INDEX(A1:E25,MATCH(F1,A1:A25,0),MATCH(F2,A1:E1,0) ) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "atomlin" wrote in message ... I'm trying to LOOKUP value #1 in one cell, then LOOKUP value #2 in a second cell. Based on the result of those 2 LOOKUP's, I want the furmola to return the correct value from the intersection of the LOOKUP results in a table of data. I'm stumped...is this possible? Thanks in advance... :D |
|
#3
|
|||
|
|||
|
It is hard to tell exactly what you are trying to do. Check out the Indirect, HLookup, and VLookup functions. If these don't do what you want, repost and be a little more specific. Szalapski -- TommySzalapski ------------------------------------------------------------------------ TommySzalapski's Profile: http://www.excelforum.com/member.php...o&userid=25561 View this thread: http://www.excelforum.com/showthread...hreadid=395511 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Lookup Function Problem | Excel Discussion (Misc queries) | |||
| Lookup function w/Text and Year | Excel Worksheet Functions | |||
| double lookup, nest, or macro? | Excel Worksheet Functions | |||
Linear Mode
