Đã Hủy

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.

Kĩ năng: Excel

Xem nhiều hơn: 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

Về Bên Thuê:
( 0 nhận xét ) United States

ID dự án: #1692085

2 freelancer đang chào giá trung bình $50 cho công việc này


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 trong 1 ngày
(53 Nhận xét)

Please check PM. Thanks

$40 USD trong 1 ngày
(53 Nhận xét)