Link to home
Start Free TrialLog in
Avatar of Ladkisson
LadkissonFlag for United States of America

asked on

Lookup formula that links 2 parameters

I need a formula that will return data for the following condition: it needs to lookup a state, then the corresponding date(fiscal week) and return a value (total):

State      FISCAL_WEEK      Total
OH      2013 WEEK 09      0.60
OH      2013 WEEK 10      0.60
OH      2013 WEEK 11      0.60
OH      2013 WEEK 12      0.60
OH      2013 WEEK 13      0.60

Please refer to the attached file. Thank you!
Lookup-with-multiple-parameters.xlsx
Avatar of NBVC
NBVC
Flag of Canada image

There are duplicate states in different regions... does regions matter?  If not, are you looking for total of all totals for the state/week combo?

Also, can helper column be involved?
Avatar of Ladkisson

ASKER

correct - one state can be in multiple regions. pls see the attached file and refer to sheet 1 and sheet 2 for reference.
Lookup-with-multiple-parameters.xlsx
ASKER CERTIFIED SOLUTION
Avatar of NBVC
NBVC
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial