+ Reply to Thread
Results 1 to 3 of 3

combine 2 ranges and match

  1. #1
    Forum Contributor
    Join Date
    12-23-2007
    Location
    chennai india
    MS-Off Ver
    2010
    Posts
    141

    combine 2 ranges and match

    I have named ranges and trying to find out if the said value is there. It works when two ranges are matched separately, but I am not able to trace how to combine it. I have to match in a cell around 10range & 10 variable.

    =IF(ISNUMBER(MATCH(2,blue,0)),,2)&IF(ISNUMBER(MATCH(2,grey,0)),,2)&IF(ISNUMBER(MATCH(3,blue,0)),,3)&IF(ISNUMBER(MATCH(3,grey,0)),,3) – result 3- works perfect as grey range has not 3.

    But when I try to combine it does not work
    =IF(ISNUMBER(MATCH(2,((blue*grey)),0)),,2) result 2 while range blue has 2
    =IF(ISNUMBER(MATCH(2,(OR(blue,grey)),0)),,2) result 2 while range blue has 2
    =IF(ISNUMBER(MATCH(2,(AND(blue,grey)),0)),,2) result 2 while range blue has 2

    I have to combine around 10 range & 10 match(result in a ingle cell) so I want to shorten the formula. Also to take care that some cell may have their places in both cell. Like Red(a1,b1,c1) & blue(a1,a2,a3)
    Where a1 is common in red and blue.

    Thanks in advance as always i have received best answers to my querry from this forum

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,167

    Re: combine 2 ranges and match

    Its not very clear on what you are trying to do. You could try with attaching a sample workbook so we can understand better.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Forum Contributor
    Join Date
    12-23-2007
    Location
    chennai india
    MS-Off Ver
    2010
    Posts
    141

    Re: combine 2 ranges and match

    ihave attached a file
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1