Đã 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 thêm: write programming code, see programming, programming latest, programming help needed, programming change, matrix programming, matrix bpo, write programming excel, home programming, freddie mac, excel help needed, excel data programming, e programming, d programming, bpo matrix, vlookup table, excel help formula, programming home, today data, row b, price excel, home value, excel vlookup, excel formula, data matrix

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

Mã Dự Án: #1692085

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

nagybatonyi

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 Giá)
5.7
bouslimi1979

Please check PM. Thanks

$40 USD trong 1 ngày
(53 Đánh Giá)
5.5