Finding a Row Number for a cell

Hello,

I have two sheets. Both sheets have 2 column of data. What I want is, compare a particular cell in Sheet2 with first column data in sheet1 and find the cell which has identical value and my result I want the row number where that cell is.
I was using the IF functions as follows:

=IF(A1='Sheet1'!A1:A120,1,0)
this compares A1 in sheet2 with entire column A in sheet2 but returns 1 if it find a matching value.

How can I get it to return the row number with the match cell in sheet1?
Hope I am clear.
Thanks

Thanks Noob, It works great one more quick question in continuation to the one before.
After using the MATCH formula I get the field, what I am trying is get the field value at sheet1!B(that particular row value)
How can I put this in one big formula?

Dont worry!
I figured it out.. Used the Index method along with MATCH function.
INDEX('Sheet1A1:C5,MATCH(Sheet2!A1,Sheet1!$A$1:$A$20,0),3)

Thanks