=MATCH(value1&value2,$A$1:$A$100&$B$1:$B$100,0)

which is an array formula, so commit with Ctrl-Shift-Enter.

It will return an index into the array, so if it does not start at row 1,
you need to adjust it.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"owl527" wrote in
message ...

Hi,
Could you please let me know how I could display the row number that
meet two conditions? Please let me know. Thanks.


--
owl527
------------------------------------------------------------------------
owl527's Profile:
http://www.excelforum.com/member.php...o&userid=20916
View this thread: http://www.excelforum.com/showthread...hreadid=501599