Hi Max
Took some time...sorry. Have been trying a while with your tip, but I can't
find the "MATCH"-function on a danish computer...unless...is it in the newest
excel-version ?
Thanks a lot!!
Merry x-mas
THerese

"Max" wrote:

Ah, that's much simpler

Place in A14, normal ENTER will do:
=INDEX(B1:B13,MATCH("x",A1:A13,0))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Therese" wrote:
Hi again
Thanks. Uh...I forgot to say...There are several words in each column!
Next to each column I have another column with an x. I wanted something
like..IF
A1:A13=x, then the word in column B right next to the x, would come out in
A:14.
Oh no...hope I make it understandable!!
Therese