Index Formula help

Leslye Jackson

Hi All,

I was hoping for some feedback on this index formula I am working on. I have mapped other sheets before but this time I am getting some push back.

So I took a screenshot of the sheet. The first issue I notice is that when I try to use [Account Number]2 it errors out. This same formula works using [Account Number]@row but it does not work in the cell it needs to Center Name.

=INDEX({KO request Range 3}, MATCH([Account Number]@row, {KO request Range 5}, 0))

I am not sure what I am doing wrong. Any help would be greatly appreciated.

Center Name1.PNG

Center Name.PNG

Paul Newcome

Are you getting an error or unexpected return?

Leslye Jackson

Hey Paul! I would say both because the formula is the same in Comments column but for Center Name it shows No Match. When copied it shows Avalon which is an unexpected return.

Paul Newcome

Well the reason for it pulling an unexpected result for row 3 is because there is no account number.

For row 2, make sure that same exact account number is present in the {KO request Range 5} range.

If it is present, how is it populated in each of the sheets?