#REF!

[Steved]

Hello from steved

=IF(ISNA(VLOOKUP(A5,ParadoxBusType!
$H$2:$H$25,10,0)),"",VLOOKUP(A5,ParadoxBusType!
$H$2:$H$25,10,0))

I get a #REF! for the above why please

Thankyou.

 

[Guest]

Try "ISERROR" instead of "ISNA"

guess, it would work

 

[Govind]

Hi,

Its bcos you have given the range as only H2:H25 which has only one
column H whereas in lookup, you want to get the 10th column position
from column H.

Your formula should be something like

=IF(ISNA(VLOOKUP(A5,ParadoxBusType!
$H$2:$H$25,1,0)),"",VLOOKUP(A5,ParadoxBusType!
$H$2:$H$25,1,0))

or it should be
=IF(ISNA(VLOOKUP(A5,ParadoxBusType!
$H$2:$Q$25,1,0)),"",VLOOKUP(A5,ParadoxBusType!
$H$2:$Q$25,1,0))

Regards

Govind.

 

[Steved]

Thankyou Q was what I was missing

Cheers.

-----Original Message-----
Hi,

Its bcos you have given the range as only H2:H25 which has only one
column H whereas in lookup, you want to get the 10th column position
from column H.

Your formula should be something like

=IF(ISNA(VLOOKUP(A5,ParadoxBusType!
$H$2:$H$25,1,0)),"",VLOOKUP(A5,ParadoxBusType!
$H$2:$H$25,1,0))

or it should be
=IF(ISNA(VLOOKUP(A5,ParadoxBusType!
$H$2:$Q$25,1,0)),"",VLOOKUP(A5,ParadoxBusType!
$H$2:$Q$25,1,0))

Regards

Govind.



.