Return the filtered results of a table to a specific cell

Say I have a table like such:

[A1] [B1] [C1]
1 cat green
2 dog orange
3 cow red
4 pig black

Now say I filter by Column 1, and select to only filter for "2". The result looks like:

[A1] [B1] [C1]
2 dog orange


I need a completely separate cell (not part of the table, say E1) to display the first visible cell in column 2. So in this case, E1 would display "dog". If I re-filtered for "4", it would now display "pig". The closest function I've found would be SUBTOTAL, but that only works on numbers. My filters will be unique meaning only one row will be visible, if that makes it any simpler.

Thanks

Hi
I hope I haven't misunderstood and know this may be a little simplistic but,
If you are seeking to reproduce a value in the first visible cell, if your filter returns Dog, Pig etc into the B column then wouldn't simply putting =B1 in cell E1 work?

Bobsone: The problem is when I filter results of a table, the first visible row won't necessarily be in row 1. So entering =B1 will always display whatever is in B1, and be unaffected by my filter

canapone: The service row with subtotals and match works perfectly. Thanks for the example file, that made it easy to understand.

Bobsone: The problem is when I filter results of a table, the first visible row won't necessarily be in row 1. So entering =B1 will always display whatever is in B1, and be unaffected by my filter

canapone: The service row with subtotals and match works perfectly. Thanks for the example file, that made it easy to understand.