I have 2 separate tables and I am looking to pull a value from 1 table into the other. I have tried multiple If statements, Vlookups, etc.. but can't seem to wrap my head around the proper logic.
I need to pull "DA Spend" from the left table to the right table. In order to pull this correctly i need the State and SKU to match in both tables. I also need to match the pricing if "Sale Price" on the right table is +/- $1 from "Suggested Price" on the left table
I highlighted an example of what I'm talking about. Table 1 is what I'm expecting the price to be, and table 2 is what the price actually was. For my purpose, i am assuming that if the "Sale Price" (Table 2) is within $1 of the "Suggested Price" (Table 1) then the DA $ should apply to Table 2 price.
I need to pull "DA Spend" from the left table to the right table. In order to pull this correctly i need the State and SKU to match in both tables. I also need to match the pricing if "Sale Price" on the right table is +/- $1 from "Suggested Price" on the left table
I highlighted an example of what I'm talking about. Table 1 is what I'm expecting the price to be, and table 2 is what the price actually was. For my purpose, i am assuming that if the "Sale Price" (Table 2) is within $1 of the "Suggested Price" (Table 1) then the DA $ should apply to Table 2 price.
