arbitary lookups

[Greywolf77]

I'm not familiar with More advance commands of excel,so is there a way to get excel to lookup a vslue which will have multiple listings, check it against another value in the same table and display a value on the same row.

Column A Column D Column E - V
Mod Number Line Number Values I need displayed

The line numbers are the first criteria for the search, which will have possible multiple listing for the same line, the module is what I need it checked against, this will be a single specific list, and display values from other columns as I need.


Example

Column A Column D Column E Column F
04-034-13A ga-aaa-3-2400 7665 Air
04-034-13A ga-aaa-4-2440 3000 Glycol
04-034-12A ga-aaa-3-2400 7665 Air
04-034-12A ia-aaa-12-4765 1138 Air
04-036-09A ga-aaa-3-2400 3000 Air
04-036-09A rs-baa-8-3458 2940 Glycol

Need to lookup ga-aaa-3-2400 04-034-12A and have excel display 7665.

 

[Aladin Akyurek]

I'm not familiar with More advance commands of excel,so is there a way to get excel to lookup a vslue which will have multiple listings, check it against another value in the same table and display a value on the same row.

Column A Column D Column E - V
Mod Number Line Number Values I need displayed

The line numbers are the first criteria for the search, which will have possible multiple listing for the same line, the module is what I need it checked against, this will be a single specific list, and display values from other columns as I need.


Example

Column A Column D Column E Column F
04-034-13A ga-aaa-3-2400 7665 Air
04-034-13A ga-aaa-4-2440 3000 Glycol
04-034-12A ga-aaa-3-2400 7665 Air
04-034-12A ia-aaa-12-4765 1138 Air
04-036-09A ga-aaa-3-2400 3000 Air
04-036-09A rs-baa-8-3458 2940 Glycol

Need to lookup ga-aaa-3-2400 04-034-12A and have excel display 7665.

Control+shift+enter, not just enter:

=INDEX($E$2:$E$7,MATCH(1,IF($A$2:$A$7="04-034-12A",IF($D$2:$D$7="ga-aaa-3-2400",1)),0))