Heather,

I assume you have a reson for only executuing your lookup if A20 0 because
it may be a bit unusual to check a value in your lookup vector but it's not
affecting the formula. In fact it works perfectly for me so can you expand
how it is going wrong.

Mike

"Heather C" wrote:

I'm trying to match a UPC # to an Item number on an invoice. I put the
formula in and it bring up thewrong item number. I'm not quite sure how to
fix this. The formula I'm using is
=IF (A200, LOOKUP(C20,Sheet1!A:A,Sheet1!B:B),"")

PLease HELP