MATCH against > 65534 rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Given the formula
=IF(ISNUMBER(MATCH(AN2,$AG$2:$AG$65534,0)),"Matched","Unmatched")

is there a way to have MATCH test a similar range on another sheet? Or am I
stuck doing this formula on two separate sheets?

Yes, this type of thing can be done in Access, but it would be so much
cooler if I didn't have to do that. And, no, installing XL 07 on this
computer is not an option.

Dave
 
=IF(ISNUMBER(MATCH(AN2,$AG$2:$AG$65534,0)),"Matched
Sht1",IF(ISNUMBER(MATCH(Sht2!AN2,Sht2!$AG$2:$AG$65534,0)),"Matched
Sht2","Unmatched"))

Returns a match on first found value only.

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

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------­------------------------------­----------------
 
It just occurred to me that I need only do a nested if statement here.

Problem solved.

Duh, should have been obvious!
 

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

is MATCH a volatile function? 3
Complex match 1
If cell empty delete row 1
Help with rest of forumla - Delete rows based on criteria 4
Matching Columns in work sheets and copying both rows to new 1
Setting up barcode 2
Multiple Matched Lines 7
Compare sheets for matches 2

Back
Top