Forum Discussion
Selecting a text from a range of cells
In D3:D10 there is one cell that has a text value, the remaining are empty or have a hyphen. In D11 I want to find and enter the text value that appears in the range, D3:D10.
Am trying nested IF statements, but getting tied up in knots. Anyone have any suggestions for me please? Thank you.
2 Replies
Hi, Allan!
You could try:
=LOOKUP(2,1/ISTEXT(D3:D10)/(D3:D10<>"-"),D3:D10)
Blessings!
John, this is excellent...it has produced what I'm looking for.
Now I am trying to understand the formula so that I can learn what is going on! Can you give me a clue?
Allan
