Help hide my #N/A error!

[EXCEL??]

I am sorry to ask a really stupid question but I just cannot get my head around how to hide an #N/A error when a cell in the argument has not yet been filled.

My simple formula is:

=VLOOKUP(A30, E5:F18, 2, FALSE)

I have been reading lots about 'IFs' and 'ISERRs' but can't get either of them to work. Clearly I am doing something wrong but my formula is definitely correct, it is just waiting for someone to type a code into 'A30' but while 'A30' is blank, I would like this cell to be blank too rather than showing an error.

Any advice would be greatly appreciated.

[tom1977]

try this

=IFERROR(VLOOKUP(A30, E5:F18, 2, FALSE),"")

[JieJenn]

Use

=IFERROR(VLOOKUP(A30, E5:F18, 2, FALSE),"")

[Oeysbrei]

Hi,

Is it possible for you to attache a samplefile?
That would make it easyer for help.

but you can try this formula:

=IFERROR(VLOOKUP(A30, E5:F18, 2, FALSE);"")

[Søren Larsen]

If it's because you're having troubles translating the formulas, there is a good translator here:

http://wwwhome.ewi.utwente.nl/~tries...cel/excel.html

IFERROR() is not on the list, but I think it is HVIS.FEIL()