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