IF and COUNTIF

[Nanaia]

This is one of those 'how do I say this' situations.
I need to pull data from a specific column but only if the adjacent cell has a value. For example, I need B25 in TAB2 to search column E in TAB1 and if it finds a cell with a value, pull the name from that adjacent cell in column F in TAB1. The catch is I need it to look at all of the columns and when it finds the next cell in column E in TAB1 that is not blank then pull in the name next to it. I hope this makes sense. I can't use the XL2BB program on this computer so I've attached a screenshot of an example of TAB1. Given this example, I need the results for B25 to display Name3 and B26 to display Name7.
It's one of those "I know there's a way but I just don't know how" scenarios - unless I'm wrong. And, since it's Monday, I could very well be wrong.
Thank you for any help.

 

[Fluff]

How about

=FILTER(Sheet1!F1:F100,Sheet1!E1:E100<>"")

 

[steve the fish]

Do you mean like this?

=FILTER(F1:F20,E1:E20<>"")

 

[Nanaia]

@Fluff and @steve the fish -- YOU GUYS ARE ROCK STARS! That works perfectly for the first row!! Thank you! ? Any suggestions on how to tweak it for the for the additional rows (Name7 and any others that show up)? The formula will need to be used in thirteen cells in the same column to pull up to thirteen names. When I copy the formula down it keeps providing only Name3. And when I fill all thirteen cells with the formula I get a #SPILL! error. I'm thinking an IFERROR added to the front will take care of the spill, but how do I resolve it picking the names correctly?

 

[Fluff]

Just put the formula in one cell & it will spill down.

 

[Nanaia]

Just put the formula in one cell & it will spill down.

Well isn't that clever! Thank you. ?

 

[Fluff]

Glad we could help & thanks for the feedback.