marshybid
05-25-2008, 03:31 AM
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
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