Hi everyone,

Sorry if this is a repeat thread.

Please see screenshots below.

I'm trying to move a value from Sheet 1 over to Sheet 2 based on multiple criteria. I got close with the formula below, but it looks like it is pulling the value from the FY17 column B (0) instead of FY19 column C (2,200). I cannot figure out how to add additional criteria in the formula to specify that I want the value from the FY19 column.

=IFERROR((VLOOKUP($B9,'Sheet 1'!$A:$C,MATCH(A$9,'Sheet 1'!$A$2:$C$2,0),FALSE)),0)

I also don't know if vLookup is the right choice or if I should be using Index/Match or another command. If anyone can help it would be greatly appreciated.

Thanks!

Capture.PNG

Capture1.PNG