Lookup help

  • Thread starter Thread starter paul thomas
  • Start date Start date
P

paul thomas

Hi All

Trying to basically find - if "reading" A1 on sheet 1 then find "reading" on
sheet 2 in column A and return cell No

On worksheet 1 in cell A1 = Reading

Worksheet 2 in column A = list of teams including Reading (Reading is eg A7
on this list)

Result A7

Not having much joy - I must be looking at it the wrong way.

Any help greatly welcome

Thanks
Paul
 
Since you already know that Column A contains your data, would the row
number be good enough for you?

=MATCH(A1,Sheet2!A:A,0)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Hi All

Trying to basically find - if "reading" A1 on sheet 1 then find "reading" on
sheet 2 in column A and return cell No

On worksheet 1 in cell A1 = Reading

Worksheet 2 in column A = list of teams including Reading (Reading is eg A7
on this list)

Result A7

Not having much joy - I must be looking at it the wrong way.

Any help greatly welcome

Thanks
Paul
 
Back
Top