Good morning everyone,
First time posting but I have browsed through here before. I have a sheet that I am trying to do a couple things and I think I am close, but something is off.
Goal 1: Based on Zip Code return a climate zone with VLookup (Check, this part works. L2-L57 when entering a CA zip code will return the corisponding climate zone as it relates to the "Tables Tab"
Goal 2: Based on that cimate zone entered AND the measure it relates to it returns the proper savings.
More information. There are a total of 56 Measures and 16 Climate Zones. All the savings are different. The purpose it for this. If we have a program in city X and install X measures the savings for those measures will be [output]. ThWORKBOOK TEMPLATE.zipWORKBOOK TEMPLATE.zipe workbook is to be used in multiple scenarios.
Potential Problems: Here is the formula I currently have: =INDEX(Tables!M4:FB25,MATCH(A10,Tables!M3:BP3,0),MATCH(M10&N1,Tables!K4:K25&Tables!M4:M25,0))
Returns:#N/A
I believe it could be partly because I am referencing a column on the "Return" page to that of a row on the "Tables" page.
I am not sure what else could cause it. I also am not sure how else to set up that data without that being a problem one way or the other. Maybe I am not "Matching" correctly?
I will upload the workbook too. FYI the only values for "Savings" I have entered so far are for ASH controllers. I want to make sure this works before entering a bunch more.
Thank you. Hopefully I outlined this enough for you.WORKBOOK TEMPLATE.zip
Bookmarks