I finally got a VLOOKUP to work:
=VLOOKUP(D4,PREVIOUS!D4:AN115,37,FALSE)
This brings in the correct value.
But since I have heard the Index and Match combined is a better method I am trying to figure out why this does not work:
=INDEX(PREVIOUS!A4:AN115,MATCH(GE!D4,PREVIOUS!D4115,0),PREVIOUS!AN4:AN115)
It's on the same sheets, same data.
Also, how do I increment only the compare cell with an auto fill? When I copy down the column all the Row/Column values increase as well as the compare cell.
Joel
=VLOOKUP(D4,PREVIOUS!D4:AN115,37,FALSE)
This brings in the correct value.
But since I have heard the Index and Match combined is a better method I am trying to figure out why this does not work:
=INDEX(PREVIOUS!A4:AN115,MATCH(GE!D4,PREVIOUS!D4115,0),PREVIOUS!AN4:AN115)
It's on the same sheets, same data.
Also, how do I increment only the compare cell with an auto fill? When I copy down the column all the Row/Column values increase as well as the compare cell.
Joel