A 2003 friendly version of a 2007 formula

[dhally]

Hello,
Is there a 2003 friendly version of this 2007 formula?:

=IFERROR(IF(VLOOKUP(A67,MroLookup,14,0)="","",VLOOKUP(A67,MroLookup,14,0)),"")

 

[Jonmo1]

Try

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

 

[Jonmo1]

Could be even better too...
What type of data is returned by the vlookup ? Text or Number ?

 

[dhally]

Try

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

Thank you very much jonmo1..!

 

[hiker95]

dhally,

Maybe:
=IF(ISERROR(VLOOKUP(A67,MroLookup,14,0)),"",VLOOKUP(A67,MroLookup,14,0))

 

[dhally]

dhally,

Maybe:
=IF(ISERROR(VLOOKUP(A67,MroLookup,14,0)),"",VLOOKUP(A67,MroLookup,14,0))

hiker95:
both formulas seem to work, however I'm getting a return value of "0" in some cells that should be a blank.

 

[Aladin Akyurek]

Hello,
Is there a 2003 friendly version of this 2007 formula?:

=IFERROR(IF(VLOOKUP(A67,MroLookup,14,0)="","",VLOOKUP(A67,MroLookup,14,0)),"")

If the formula is expected normally to return text...

=LOOKUP(REPT("z",255),CHOOSE({1,2},"",T(VLOOKUP(A67,MroLookup,14,0))))

 

[dhally]

If the formula is expected normally to return text...

=LOOKUP(REPT("z",255),CHOOSE({1,2},"",T(VLOOKUP(A67,MroLookup,14,0))))

Aladin Akyurek,
Actually the previous post about some cells still returning a "0" was my fault. I didn't enter the formula correctly given by jonmo1...my bad.

For the record, the formula is working perfectly in a 2003 enviornment now.