If(Isna(vlookup(......),0,vlookup(......))

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Anna" wrote:

Hello,
I'm working in Excel 2000. I'm using the vector lookup function in my
current worksheet to find a specific item number in column A and the quantity
on order in column C in another worksheet. Everything is working fine except
that if the lookup can't find the item number and quantity I'm looking for,
it returns the highest quantity value it finds. How I do get the lookup to
return a 0 in the cell if the item number and quantity are not listed in the
external worksheet?

In summary, I want excel to tell me that it can't find the infomation that
I'm looking for and return a 0. Thank you for your help.