Index Match UPC/Qty

[jeffb87]

Hi Folks,
Excel newb here so I apologize in advance. Trying to match UPC codes and Qty from two sheets. One sheet (Item Sale) doesn't have quantities, but the supplement sheet does. I would like the to have the supplement worksheet fill in the qty by UPC codes, if that makes senseWhen I run this, I am getting a N/A under the Qty column. Thank you for any assistance.

=INDEX([UPC],MATCH(Table3[@UPC],Supplements!B2:B51,0))


Thanks,
Jeff

[ben_hensel]

you've got your ranges mixed up:

Please Login or Register  to view this content.

Also note this is going to still throw a ton of #N/A! errors, because there are a ton of items with UPCs on Table2 with no corresponding UPCs on Table3.

[jeffb87]

Thank you Ben for your help.