I have one spreadsheet with all the stock my supplier has available with
retail and trade prices. Columns a part number, description, retail,
trade.

I have just completed another sheet which I want to keep separate with
what stock I have in my workshop.

I wish to add another column to the supplier sheet which looks at my
stock sheet and puts the stock level in.

As I only have a fraction of what the supplier has on offer, there are a
lot of parts I don't have a stock level for. If I use VLOOKUP I can get
the stock level for the parts I have, but for all the parts I don't have
I get #NA. VLOOKUP is looking for an exact match which isn't going to
happen unless I have all the stock my supplier has.

I have tried the IF statement to try to make any #NA cell read zero, but
to no avail.

Anyone got an idea on how to make the #NA cells read zero if I haven't
that particular stock item on my sheet?
--
Gary Ridgway