Hi all,
I got a spreadsheet from someone else and I'm curious as to what part of the formula does. It seems to work without the *LEFT($G5,2) in it. Here is my formula:
=INDEX('AER Export'!$A:$N,MATCH($B5,'AER Export'!$A:$A,0,8)*LEFT($G5,2)
I have never used the * as part of an INDEX MATCH...