Help! Need to lookup referencing 2 variables
Here is what I am attempting: On worksheet 2, I want to reference worksheet
one looking at 2 variables. What I want is to reference column D if columns
I and K meet my criteria. Column I has salespeople, so text is repeated
throughout. Column J is dates. Column B is products.
I want to find a formula that will keep up with changes in data.
Please help!!!
|