Value not available error

[Ralem]

Hi,

I have the following formula:

D5: =IF(OR(D4=654,D4>656),(VLOOKUP(D4,$AF$5:$AG$50,2,FALSE)),"")

If the value in cell D4 doesn't exisit in the range of AF5:AG50 then error of #N/A appears on cell D5.

How can I edit the formula to make the cell D5 blank in this case instead of #N/A

[royUK]

Look at the ISERROR OR ISNA Functions

[Ralem]

I couldn't apply that, how to include this in my formula...

[Richard Buttrey]

Hi,

In Excel 2007,

Please Login or Register  to view this content.

in earlier versions

Please Login or Register  to view this content.

HTH

[Ralem]

Thanks a lot ;-)