I'm trying to automate this worksheet so that the table on the right will update spit out the correct numbers when the date is changed above in cell AA1. So if it has the date of 4 in it, the formulas below would use the data from row 5. Hopefully that makes sense. They are simple SUM formulas.
Use this function.
=INDEX(H:H,$AA$1)
Right table shown says for AA1=4 row 3 data is used.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
In this case...
=INDEX(H:H,$AA$1-1)
In the end it was an Index and Match function I was looking for, but both your replies set me on the right track. Thank you both.
Tks for the feedback, glad to help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks