Return target cell if its' answer is true.

  • Thread starter Thread starter Kevin M
  • Start date Start date
K

Kevin M

Hi everyone, experimenting with an AND formula and i'm
looking for some guidance.

Columns L, N, O, and P that contain the data, if one or
more of them are empty, i'd like the formula to return
which one(s) are empty as my answer in Col Q.

That's about all the info..
TIA
Kevin M.
 
In any cell on row 1

=IF(L1="","L","")&IF(N1="","N","")&IF(O1="","O","")&IF(P1="","P","")

and copy down. Havent included Row number as that should be obvious from the
location of the formula
 
Thanks Ken, i guess a few more minutes of thinking would
have saved me wasting your time.

Kevin
 
It's never wasted. You never know when someobdy else will come across the
thread in Google and say "Ahhh - That's how you do it". Keep posting :-)
 
Back
Top