=MATCH("abc",$A$1:$A$30,0)=MATCH("def",$B$1:$B$30, 0)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------



"Karmen" wrote in
message ...

Hello,
I am a bit frustrated....In my spreadsheet, I would like to verify if a
particular name and a particular city are located on the same row. How
can I check a spreadsheet that has 100 rows to verify if the same
name/city are on the same row?


--
Karmen
------------------------------------------------------------------------
Karmen's Profile:
http://www.excelforum.com/member.php...o&userid=30972
View this thread: http://www.excelforum.com/showthread...hreadid=506387