Share via

Excel Highlighting value differences between 2 sheets

Anonymous
2022-11-21T03:32:57+00:00

2 separate excel sheets. 1st sheet column A has upc codes and column B has price. 2nd sheet has the same layout as sheet 1. how do I compare prices of upc in the 2 sheets? both sheets have different amount of entries.. Example 1st sheet is a master list of upc/price. There are 12000 rows. When receiving an order I would like to verify the price in the order compared to my master list. The order may have only 2 rows or 3000 rows. Can Excel highlight the order sheet price if different from the master sheet? Thank you.

example sheet 1 MASTER Liist example sheet 2  ORDER Sheet
UPC Price UPC Price
000000000001 $6.23 000000000003 $10.23
000000000002 $5.74 000000000008 $8,213.01
000000000003 $10.23 000000000017 $20,521.68
000000000004 $9.87 000000000021 $25,995.00
000000000005 $6,842.31
000000000006 $5,477.76
000000000007 $6,845.39
000000000008 $8,213.02
000000000009 $9,580.65
000000000010 $10,948.27
000000000011 $12,315.90
000000000012 $13,683.53
000000000013 $15,051.16
000000000014 $16,418.79
000000000015 $17,786.42
000000000016 $19,154.05
000000000017 $20,521.68
000000000018 $21,889.31
000000000019 $23,256.94
000000000020 $24,624.56
000000000021 $25,992.19
000000000022 $27,359.82
000000000023 $28,727.45
000000000024 $30,095.08
Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ashish Mathur 102K Reputation points Volunteer Moderator
    2022-11-21T23:51:20+00:00

    Hi,

    In cell F2, enter this formula and copy down

    =VLOOKUP(D2,$A$2:$B$25,2,0)

    Hope this helps.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2022-11-22T04:55:21+00:00

    Hi,

    Please check whether the following solution is helpful:

    Step 1) Please click on cell F2.

    Please select range F2:F5.

    Step 2) Click on Home tab.

    → Click on Conditional Formatting drop-down.

    → Click on New Rule >> a dialog box will open.

    → In the dialog box >> in the top-half, select Format only cells that contain.

    → In the dialog box >> in the bottom-half, select the options as illustrated in the screenshot.

    → Write the formula: =VLOOKUP(E2,$A$2:$B$25,2,FALSE)

    → Click on Format button to apply formatting.

    RESULT

    Please respond if You require further assistance. I will try My best to be of help.

    If I was able to help You, please mark My response as answer and helpful.

    Thank You!

    Was this answer helpful?

    0 comments