VLOOKUP Column AA & AB

[Excelllllllllllllllllllll]

Hi, I have a lot of info on my file and everything was working perfectly for columns A to Z.
But when I got to looking up data from AA onward it'll come up as 0.

The formula I have is:

=IFERROR(VLOOKUP($B5,Review!$A$4:$Y$100,[COLOR=#ff0000]26[/COLOR],FALSE)*VLOOKUP($B5,Review!$A$4:$Y$100,[COLOR=#ff0000]27[/COLOR],FALSE),0)

Like I said when I was looking up Y and Z, 24 & 25 respectively everything is normal. Then when I move to the next set (AA and AB) the formula gives me 0 no matter what's in those cells.

Anyone got any idea where I'm going wrong?

Thank you in advance if you try to help!

 

[MrKowz]

VLOOKUP's table_array must contain the range that you want to return. The reason it is returning 0 is because it is actually generating a #REF error when you try to return a column which is not present in the table_array, which is being caught by the IFERROR.

Try:

=IFERROR(VLOOKUP($B5,Review!$A$4:$[B][COLOR="#FF0000"]AB[/COLOR][/B]$100,26,FALSE)*VLOOKUP($B5,Review!$A$4:$[B][COLOR="#FF0000"]AB[/COLOR][/B]$100,27,FALSE),0)

 

[Excelllllllllllllllllllll]

Duh! I added those extra tabs later.
Kind of embarrassed by my blonde moment there, but thank you so much for helping!

 

[MrKowz]

Duh! I added those extra tabs later.
Kind of embarrassed by my blonde moment there, but thank you so much for helping!

Happy to help - we all have those moments, so no worries! Have a good day.