I've been playing around with an IF Function and nesting a VLOOKUP without
any luck.

I've got a table which has a list of post codes with corresponding values
against each. In a separate worksheet I have a list of post codes and where
there are post codes the VLOOKUP function works and finds the value; however
there are circumstances where the post codes are different and I rather than
produce a FALSE statement and put N/A in the column I want it to add a
different numerical value.

I do not know all the post codes so I cannot add these to the VLOOKUP table.
I need the VLOOKUP table to record the exact values that correspond to the
post codes.

HELP Please
--
David