Search in data without collapsing the rows with table?

[horsefish01]

In this workbook, when looking in SHEET, in the office I'd be like "Okay TICKET 2 passed 50025" - but is there someway I can make it so that it's easy to then somehow can choose ticket 2 and then make the list in column E/F only show the "giver"/"Amount" from ticket 2?

Normally I would make a table and just have "tickets" in column D, but in some cases that would collaps rows in B & C that needs to be visible.

PS: The data cannot be moved around, sadly.

UNI.xlsx

[Aardigspook]

First, put a dropdown box below your table of tickets, in B13. Then, in C13, to give you the result from the table above, put this:

Please Login or Register  to view this content.

In E3 and F3, put these and drag down:

Please Login or Register  to view this content.

They are array formulae, so enter them using Ctrl-Shift-Enter not just Enter.

Here's your file with the above working: UNI-1 _ AS (multiple lookup _ for Hansemand).xlsx

Hope that does what you want.