simple formula help: if text does not exist display specific cells from same row

[ahha_ha]

could someone help me with a simple formula to: 

if text does not exist display specific cells from same row

Formula Rule: If amount cell (col F) is blank display: Username: First Name: Last Name  (from the same row as the blank).

Thanks AL

[#2 · Accepted solution]

@ahha_ha 

In case you are MS365 subscriber, this (in F26) will do there trick:

=FILTER(FILTER(B2:F17,D2:D17="","-"),{1,0,0,1,1})

 Otherwise consider using a pivot table to achieve a similar result. See example in column M. File attached.

[#3]

@ahha_ha if you have office 365, filter is the best function

otherwise you need to use aggregate along with index & match not that easy, but its dynamic & you will not have any blanks, check my solution

[#4]

Thanks for your quick response and formula that works great!

[#5]

This formula also works great, thanks for your time and help!