Finding data then returning data in previous column

[JTL9161]

I am looking down column B (B1:B100) for the amount of $100. When its found I want to list the names in column A (A1:A100) that have a $100 next to it.


Bob $99
Dave $100
Greg $98
Steve $100

Looking for:
Dave
Steve


Thank you,
James

 

[Joe4]

Since you are using Excel 365, how about using the new FILTER function?
Just enter this formula in any blank cell:

=FILTER(A1:A4,B1:B4=100,"")

I put the formula in cell D1 in your example:

See here for more help, description, and examples on this cool new function: FILTER function - Microsoft Support

 

[JTL9161]

thanks.

 

[Joe4]

You are welcome.

I think this FILTER function is one of my favorite new Excel functions to come along in quite a while!
It is cool how you can enter the formula in one single cells, and all the results will automatically spill to the other cells.