Locating

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
 
K

Ken Wright

=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 :)
------------------------------­------------------------------­----------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't send emails but can receive in Outlook 2019 1
Weigh tasks 0
Integrating information from Word to Excel (not mail merge) 1
Need Help with Macro Security 1
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
How to use matching values in two worksheets to return another value 5
Anything will help 0
Regarding Word Add in on Office 365 0

Top