Hi everyone!
Can someone help me with the attached sample. Assume the tables would be very large and so I'm looking to find a formula that would look for two (or perhaps 3) variables to ensure that I am returning the correct values.
In the samples attached, I'm trying to look up values in table B but make sure the actual value corresponds with the data from table A.
Table B: Discount of $17 from Store number 1 in Unit Name 1108 on specific Date 1/4/2019.
The output table highlighted in yellow is where I would like the data to go. I've create a blank table for this exercise below the Output Table.
Thank you very much for your help in this
Note: I'm able to use vlookup to capture one variable but not sure how I can match two variables from the two tables.
Bookmarks