VLOOKUP in Excel 2010, need it to work in Excel XP

[CraigG]

Hi

I've created a spreadsheet in Excel 2010. I've used many VLOOKUPs - great, apart from these now have the FALSE / TRUE option at the end. All work fine - however, I have one user who needs to use Excel XP - they receive #NAME error for the cells with the VLOOKUP, obviously because the new VLOOKUP formula only works in Excel 2010.

Anyone any ideas how I can get this formula to work in lower versions?

Thanks in advance!

Craig

 

[VoG]

VLOOKUP is exactly the same in XP and 2010 so they should not get an error.

Can you post the exact formula that is failing.

 

[CraigG]

Hi

Formula...

IFERROR(VLOOKUP(CELL,'WORSHEET'!CELL:CELL,COLUMN,FALSE),"")

Actual forumla
IFERROR(VLOOKUP($B4,'July 2011'!$B$5:$AJ$41,34,FALSE),"")

 

[Jonmo1]

It's not the Vlookup I'm sure, Vlookup is available in Excel XP.

It is likely that you have the vlookup nested in the Iferror function, in order to hide the #N/A errors when no match is found...

Something like

=IFERROR(VLOOKUP(....),"")
This makes it return "" when the vlookup results in an error.


It's the IFERROR that is not available in Excel XP..

Instead, try

=IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...))

 

[CraigG]

Brillant

Thanks both for replying.

I forgot all about IFERROR. Soon forget about the old ways of doing things!

Thanks again.

Craig