I am hoping to find a way to select a date at the top of a column and perform a look for all of the cells below it, and a different lookup for those one row to the right.
I have copied a bunch of things found and then went through chatgpt but what I'm getting from it isn't working. I originally was going to do this with xlookups on all of the cells which I finally got working, but the data behind it is huge and the user wont need all of them.
I've attached an example and the code I have is below. Also below are the formulas that work to pull the data in case that helps.
![]()
Please Login or Register to view this content.
![]()
Please Login or Register to view this content.
Bookmarks