Formula help to lookup multiple criteria on different sheets.

[abrig005]

Hello, I am trying to figure out an Index formula to copy the data in cell D3 to cell F24 and cell J8 to cell G29. Note the destination cells are in a different worksheet. There are hundreds of cells but I can figure that out once I get the main formula. Thank you very much!

 

[Eric W]

Try this in F24:

=INDEX($C$3:$G$10,MATCH(E24,$B$3:$B$10,0),MATCH(C24,$C$2:$G$2,0))

I formatted B3:B10 as Text, as well as E24. That's to prevent Excel from misunderstanding some of those values as text vs. numbers. The formula for G29 is equivalent, just change the ranges. In fact, it's possible to have a common formula if you treat your FY17 and FY18 tables as one. But see if this works for you first.

 

[abrig005]

Eric, thank you very much this works great!

 

[Eric W]

Glad to help!