I've been scouring the site to find a solution and haven't quite found one that fits my circumstance. Essentially, here is my problem:

I have a worksheet which contains a filter on 'Cardholder names'. What I would like to do is based on the filter name I choose, the name is automatically populated in another cell, and in the cell next to that one, the cardholder ID # pops up.

For example:

If I filter out all names except 'Susan Doe' in A23, then 'Susan Doe' populates in cell A4 and susan's card ID populates in cell A5. Is this possible?