Multiple IFERROR or IFERROR w/ If Statements

Hello All,
So a buddy of mine was trying to Audit an existing price list for a customer, but he seemed to be taking the long road.

If you take a look at the attachment, you will see that he does a data dump onto the Price List Query_Customer (customer price list).

On the Missing Sku Summary, he brings in data from the 2016 PLI & Price List Query_Customer.

What he basically wants to do in column H is check to see if that item is "missing" off the customer's current price list (column G).

In column H, he wants to match the same price (column G)...if the existing TYPE (Column D) & same CM size (Column E) agree.

For instance, Item# 982048 is missing a price in column H. But, we know that the same type & CM size are right above @ 1,467.95

He simply wants to see that value in Column H for that item.

Column I......can simply be a check to make sure he is getting the same discount.

Note: There are some formulas at the top in which he tries to establish a baseline discount off one item, but I asked him what happens if that sku is not in use by customer....hence the #N/A. I figure it is much easier to IFERROR w/ multiple conditions w/o any math (not necessary for his audit purpose).

Any help would be greatly appreciated.

Please treat attachment as confidential information. Thank you.

PS-> I was thinking about building a pivot table on Price List Query to simply get one price based on Product & CM, then VLOOKUP to it.

Hi Bernie, Any chance you can show me a possible solution? I would build the pivot table in the 2016 PLI since that basically gives 1 price for each sku @ each SQ CM. I would be grateful. Thanks.

Thank you Bernie. Appreciate your expertise.