the Row # from the result of Vlookup formula

[Andri]

Please help i would like to know the certain row number when using Vlookup
formula. Usually the Vlookup result the contents of we are looking for, but
for this case, i would like to know the row from that contents.

Thank you for your help.

TIA

 

[excelent]

use MATCH
remember MATCH only handle 1 column


"Andri" skrev:

 

[Andri]

Thank you for the help.

use MATCH
remember MATCH only handle 1 column


"Andri" skrev:

 

[Andri]

But how to MATCH two colums (compare two databases).
MATCH the Student Name & DOB, show me the ROW.
TQ

 

[excelent]

ok an eksamble :
say u have student name in A1:A100
and DOB in B1:B100
then put in C1 the student name and DOB in C2

C3=SUMPRODUCT((A1:A100=C1)*(B1:B100=C2),ROW(1:100))


"Andri" skrev: