Solved: VLOOKUP resuts

[marshybid]

Hi There,

I have a number of VLOOKUP formulas in my code for filtering and identifying specific data.

Example: =VLOOKUP(A1,$AA$1:$BB$234,2,FALSE)

Simple enough, the issue is that if the vlookup doesn't find the value it returns #N/A. However if I then try to use the values in that column and say IF(Z1="#N/A"," ",Z1/Y1) excel doesn't recognise the #N/A?? Can anyone help please.

Thanks,

Marshybid

[Bob Phillips]

=IF(ISNA(Z1),"",Z1/Y1)

[pnewton]

you could try this:

=IF(ISERROR(VLOOKUP(A1,$AA$1:$BB$234,2,FALSE)),"",VLOOKUP(A1,$AA$1:$BB$234,2,FALSE))

[marshybid]

Thanks to you both, these methods both work great.

Marshybid