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 :-)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

LOOKUP returning wrong values 2
IF statements with multiple criteria 2
SUMPRODUCT Returning 0 or wrong totals 11
RANDBETWEEN problems 7
Monter IF statement??? sorry long question 8
Nested IF & MAX Function 4
if any of 3 conditions is true, then answer is true 5
VLOOKUP for multiple colums 10

Back
Top