Forum Discussion
XLOOKUP search w/multiple output
You put this query up three days ago, and have had zero responses. I am going to offer an explanation: your query doesn't make sense. Not fully. It's clear that you want to be able to enter one of two data items (at the top of that blue box) and have the rest of them filled in by Excel. That IS clear. What's not at all clear is where the formula //=XLOOKUP(H8,A2:A10606,B2:B10606) fits in all of it. What cell, for example, is H8? Is it one of the ones showing in the blue box area? And where in heaven's name do you have the formula itself in all of this?
Finally, instead of images, please post the actual file. From all appearances, it's dummy data already; if not, make it anonymous so that no proprietary information is revealed. If you can't post it here in the forum, use OneDrive or Google or the equivalent and paste a link here.