Forum Discussion
Help pulling information from one tab to another.
Excel's lookup functions (LOOKUP, VLOOKUP, XLOOKUP) are designed to return a single value (or with adjacent values, in some cases). To return data from (possibly) more than one row, you should use Excel's FILTER function. See the attached workbook.
Let me refer you to the FILTER and SORT functions (which will need Excel 2021 or newer). Here, too, is a video that Microsoft created when introducing those functions.
If you need more specific help, please come back after posting a copy of that sample worksheet on OneDrive or GoogleDrive and pasting a link here that grants access.
(Posting images alone requires us to recreate the file; it's easier for us to help you if you post an actual workbook that represents the reality you're dealing with, arrayed as you have it.)