I have a minor Excel formula problem.

In my example has following data, cell A5 shows "apple", A6 shows "salt", A7
shows "sugar" and A8 shows "fish". On another hand, cell B3 is the
"criteria" data showing 3.

My question is to form an Excel formula which can extract the data from cell
"A1" and then extract the 3rd data, which is "sugar" (that is the result I
want). Althought the formula is counting from A1, but the excel formula know
the data after "apple" and "salt" is "sugar" (cell from A1 to A4 is empty),
because "sugar" is located on the 3rd in row! Do you think Excel formula has
such function?

Please advice and thanks,
Wilchong

--
Message posted via http://www.officekb.com