Hello All,
For some reason I am struggling to get the formula right on the attached workbook below and would appreciate any help I can get.
Here is what I need it to do. On Sheet 2 (Jan-Mar Compiled), when a PRODUCT UPC is entered, I need Excel to lookup the value in Sheet 1 (UPC Reference), match up the PRODUCT UPC to UPC, and then display the value from the Cost column in UNIT COST from Sheet 2. I did a manual example which is highlighted in yellow.
Any help would be amazing!
Last edited by joninmichigan; 04-28-2021 at 11:15 AM.
Could you please explain what UPC is and perhaps change your title so everyone can understand it? Be aware not all of us know your professional jargon
I just changed the title. UPC stands for "Universal Product Code". Knowing that information is not necessarily required as it is just a way to identify items as you will see in the description and in the Workbook. Thanks!
Like this ? (there are other ways)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks