Index Match with Multiple Criteria

[salloush]

Hi,

I need some help with an excel file.I have tried to do it with an index match function, and some cells come up with #NA other cells will come up with a value. Every month I pull a report (Discover Report) that has three columns. The first column is the project number, second column is the top task number, and the third column is the sub task number. Now, on the discoverer report the top task number and the sub task number is wrong for each project number.I have a report ( "Accurate File") that has majority of the projects on the discover report, and it has the right top task for each project. The right top task is called Top Task Final.

Is there anyway to pull the top tasks Final and Subtask number final from the "Accurate File" with each corresponding project number into the Discoverer Report? I tried Index/Match but I don't think I did it right? If there is any other way besides Index Match I am definitely interested.

Thanks for all help

[kev_]

is this what you want - see attached

[salloush]

this won't work for what I need to do. the reason being is that the "new top task final'' in the sheet discoverer, needs to be based on the Project Number and Top task number.
you have it just based off the project number- it needs to be based on the two criteria. the reason being is that the project number has multiple top tasks.
the same goes for the sub task number final; it needs to be based of two criteria- project number and sub task number.

does that make sense?

thanks for your help

[kev_]

No problem - will post amendment when back at PC later

[kev_]

I have added a helper column to each sheet
see attached workbook - Is this what you want?

[AliGW]

Duplicate thread closed. Continue in the original here, please: https://www.excelforum.com/excel-gen...-criteria.html