Excel - #N/A Problem

[markwales]

Afternoon Excel Guru's.....

I have a slight problem, for which I know there is a work around, but cannot remember the answer for the life of me!!

I'm doing a VLOOKUP which works fine.

The lookup either returns me a Number or a #N/A

What I need it to return is a Number or a 0

I think I need to use IF and ISERROR along with the VLOOKUP, but can't seem to get the formula correct.

Any thoughts?

Ta muchly.
Mark.

[mathare]

Can you post up the formula you are using?

[markwales]

=IF(ISERROR(VLOOKUP(A2,week1,22,0)),0,(VLOOKUP(A2,week1,22,0)))

IT WORKS!!!!!!!!!!

Sorted it Mat......many thanks for the offer of help.

Mark.