Formula not working

[Vegas01]

Hi everyone

Has anyone seen this before. I am curently building a new spreadsheet and using the following formula and it all works fine for the majority of the lines in the spreadsheeing being (337 lines)

=INDEX('Mapping'!O:O,MATCH(V80,'Mapping'!N:N,0))

I had to add a few more lines the mapping page - 5 in total

and now for those 5 lines the formula above does not work - instead I have to put the following formula in

=INDEX('Mapping'!O513:O513,MATCH(V80,'Mapping'!N513:N513,0)) - actually have to reference it to the actual line of the data I want it to look up

I have tried - this does not work

=INDEX('Mapping'!O1:O513,MATCH(V80,'Mapping'!N1:N513,0))

Just don't understand why the open reference formula does not work.

Thanks in advance

 

[Alex Blakenburg]

I agree that makes no sense. Do you by any chance have merged cells that include either or both Column O or N ?
If not can you post an XL2BB of both some working and not working example rows included.

 

[Fluff]

for those 5 lines the formula above does not work

In what way doesn't it work?
Do you get an error, the wrong value, a 0 or what?