problem..

[KisH \(Tihomir\)]

I have a problem, here is structure:
sheet1
a1 "text"

sheet2
a1 "text"
a2 number "2"

In sheet1 (a3) I need to write some formula which will search for word
"text" from sheet1 in sheet2, and when it founds word" text" in sheet2 it
needs to write number in sheet1(a3) which stands by word "text" in sheet
2( in this case sheet2(a2= number 2)).

Do you understand what I want?
Thank you!

 

[Peo Sjoblom]

=INDEX(Sheet2!$A$1:$A$1000,MATCH(A1,Sheet2!$A$1:$A$1000,0)+1)

--


Regards,


Peo Sjoblom

 

[KisH \(Tihomir\)]

=INDEX(Sheet2!$A$1:$A$1000,MATCH(A1,Sheet2!$A$1:$A$1000,0)+1)

Thank you!
I'ts working, but can you explain me step by step what formula does because
i need to do some adjustments.
Thanks.