formulla wanted

[Jerie]

I did not explained my self properly with my last post
please people try again

if cell D2 equals blank use the value of cell D3,if cell
D3 equals blank use the value of cell D4, and put the
value in F2. if no cells are blank use the value of cell
D2 and put the value in cell F2.

e.g:- D2=farm D2=blank D2=blank
D3=farm D3=farm D3=blank
D4=farm D4=farm D4=farm result F2 "farm"

thanks rgs Jerie

 

[JulieD]

Hi Jerie

please stay in the same thread as your original question .. .i now know of
four different threads with answers from both Frank Kabel and myself. If
you have problems implementing our solutions please advise as to what the
specific problems are with the solutions and what you would like to see /
have happen instead.

my last answer to you was

my understanding of what you're asking is that if
B2 = "farm" then Sheet2!D1 needs to have the word "farm" in it, however if
B2 is blank then look at
B10 if it = "farm" then Sheet2!D1 needs to have the word "farm" in it,
however if B10 is blank then look at
B18 if it = "farm" then Sheet2!D1 needs to have the word "farm" in it,
however if B18 is blank then put the word "farm" in Sheet2!D1

so as far as i can tell the only time you don't want the word "farm" in
Sheet2!D1 is when there is something other than the word farm in B2 / B10 or
B18

if so then use this formula in cell D1 of sheet 2
=IF(Sheet1!B2="farm","farm",IF(Sheet1!B2="",IF(Sheet1!B10="farm","farm",IF(S
heet1!B10="",IF(Sheet1!B18="farm","farm",IF(Sheet1!B18="","farm","")),"")),"
"))

Please let me know if it did / did not provide the outcome that you want.

Regards
JulieD

 

[Myrna Larson]

=IF(COUNTA(D24)=3,D2,IF(D2="",IF(D3="",D4,D3)))

or, if cells are filled from bottom to top, so you can't have D3 blank unless
D2 is also blank,

=CHOOSE(COUNTBLANK(D24)+1,D2,D3,D4,"All cells are blank")

 

[Frank Kabel]

Hi
you're still not very clear. Try as alternative the array formula
(entered with CTRL+SHIFT+ENTER).
=INDEX(D24,MATCH(TRUE,D24<>"",0))