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