Repeating values in multiple columns

i'd do it this way putting a helper column in c
then B1 will give row.(but remember if two lots of data are repeated it will only give first row found)

ok try using either of these array formulas
they need to be entered with ctrl+shift+enter

=MATCH(A2 & CHAR(1) & B2, A4:A11 & CHAR(1) & B4:B11, 0)+3

this applies to sheet I have attached it's in C2
or

=MATCH(1, (A2=A4:A11) * (B2=B4:B11), 0)+3

in D2
apparently the second is the one to go with! no idea why

you would have to adjust cell ref as required
note the +3 at end is to return the correct row from sheet as data does not start until row 4 else it would tell you say, martin smith was in row 1