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



"excelent" wrote:

use MATCH
remember MATCH only handle 1 column


"Andri" skrev:

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