View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
I M Desperate!!! I M Desperate!!! is offline
external usenet poster
 
Posts: 1
Default 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!!!