Excel Programming Needed TODAY! ASAP!

Select a Date between Two Date Rows, then the Column State and return Table Matrix Values

I am looking for formula help in trying to write a code to pick the date from column C, in the Input Tab, and choose the row in the Freddie MAC Home Price State Index Tab that it is "closest" to it, by MONTH.

Once this date row is selected in the Freddie Mac tab, I then need the formula to next see which state (Column A in the Input Tab), the "latest" BPO Value is in (Column B in the Input Tab), and then to select that home price index value in the Fannie Mae Tab.

Finally, I need the Percentage Change in home price indexes for that state from the specific date row, specific state value to the most recent value from the bottom of the Fannie Mae tab, of course from the SAME state column of data. This will give me the percentage change in value the home price has faded or increased by, and will be placed into Column D of the Input tab. From there I can determine the "corrected" home value in column E by applying the percentage change value.

I've tried VLookUP, SumProduct, Match, Index, etc functions, clearly, I do not know how to write the code correctly.

Any help, quickly, would be most appreciated. Thank you very much.

Taidot: Excel

Näytä lisää: write programming code, see programming, programming latest, programming in excel, programming home, programming help needed, programming functions, programming for mac, programming for excel, programming change, need help in programming, matrix programming, matrix bpo, mac programming, how to write programming in excel, how to programming, how to do programming, home programming, help in programming, functions programming, functions in programming, freddie mac, excel help needed, excel data programming, e programming

About the Employer:
( 0 reviews ) United States

Projektin tunnus: #1692085

2 freelanceria on tarjonnut keskimäärin 50 $ tähän työhön


If you send me the spreadsheet I'll try to help you immediately. Do you need the formulas only or also a macro generating the formulas? Regards

60 $ USD 1 päivässä
(53 arvostelua)

Please check PM. Thanks

40 $ USD 1 päivässä
(53 arvostelua)