Index Match with * LEFT

[MrsFraser07]

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 before. What does it do? Really appreciate the help, I tried Googling all of this but didn't get my answers.

Shari

 

[Fluff]

Firstly that formula doesn't formula doesn't work,can you check that you have entered it correctly?
Also what is in G5?

 

[MrsFraser07]

Firstly that formula doesn't formula doesn't work,can you check that you have entered it correctly?
Also what is in G5?

The formula does work, sorry I missed a bracket when typing it here. It should have been: =INDEX('AER Export'!$A:$N,MATCH($B5,'AER Export'!$A:$A,0),8)*LEFT($G5,2)

I actually think I got it figured out. In Cell G5 there was a space before the first character in the text string. This is what is in cell G5. " 1 [PVS_Abandoned_Well] " So, the formula is finding a match and then multiplying it by 1. For some reason I thought the *LEFT($G5,2) was part of the INDEX MATCH and I couldn't see what it was doing, but yet it worked! Wanted to know why.

 

[Fluff]

Glad you figured it out & thanks for the feedback