Sorry an elderly moment your formula isn't on sheet 1 so your not checking a
value in your lookup vector. Last comment remains true, your formula works
perfectly for me so what is your error?

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