Locating

  • Thread starter Thread starter Karmen
  • Start date Start date
K

Karmen

Hello,
I am a bit frustrated....In my spreadsheet, I would like to verify if
particular name and a particular city are located on the same row. Ho
can I check a spreadsheet that has 100 rows to verify if the sam
name/city are on the same row
 
=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 :-)
------------------------------­------------------------------­----------------
 
Back
Top