+ Reply to Thread
Results 1 to 8 of 8

Compare value on a range if match list linked column

  1. #1
    Forum Contributor
    Join Date
    07-01-2012
    Location
    ZA
    MS-Off Ver
    Excel 2013
    Posts
    300

    Compare value on a range if match list linked column

    Goodday people

    I am newby and I hope someone can assist me. The spreedheet is attached for reference.Column A is linked to column B and both got values. I am looking for a formulae or macro to take the value in column B and compare it to the range of F1-J3 and if the number match any of those numbers the linked colum A number must be listed in column F -as per example A7 have a value of 6 that match G2. So there is 15 cells that must be checked on column B and if a match exist then the linked columnA number must be displayed in columnF.So 1 need to be displayed in column F7

    Apologies I hope it make sense I tried a formulae but did not succeed and dont know how to make it work.I am sure a Excel guru can help me -Rep will be given -thank you in advance for any help.

    Sample uploaded

    Ricklou
    Attached Files Attached Files

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,649

    Re: Compare value on a range if match list linked column

    Try this.....

    In F7
    Please Login or Register  to view this content.
    and copy down.

    Does this help?
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Forum Contributor
    Join Date
    07-01-2012
    Location
    ZA
    MS-Off Ver
    Excel 2013
    Posts
    300

    Re: Compare value on a range if match list linked column

    Hi Sktneer thank you for your response that display 1 on all if I copy it down....It must only display column A number if the B column has a match on F1-J3. as per example a8 have a value of 9 which matches J9.

    Thanks in advance -its simple but I dont know formulaes
    Last edited by ricklou; 03-28-2015 at 01:39 PM.

  4. #4
    Forum Contributor
    Join Date
    07-01-2012
    Location
    ZA
    MS-Off Ver
    Excel 2013
    Posts
    300

    Re: Compare value on a range if match list linked column

    That formulae dont work if I copy it down -it makes every cell a 1. F8 must show a 2 if it works after copying it down A11 which have a value of 0 dont match so there should be no match thus displaying nothing.Hope it make sense now
    Last edited by ricklou; 03-28-2015 at 01:48 PM.

  5. #5
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,649

    Re: Compare value on a range if match list linked column

    See the attached. Isn't this what you are trying to achieve?
    Attached Files Attached Files

  6. #6
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,649

    Re: Compare value on a range if match list linked column

    Check the Calculation Options. I suspect it is set to Manual. Set it to Automatic.

  7. #7
    Forum Contributor
    Join Date
    07-01-2012
    Location
    ZA
    MS-Off Ver
    Excel 2013
    Posts
    300

    Re: Compare value on a range if match list linked column

    That works perfectly now.......Thank you so much sktneer for your assistance -fabulous and rep given thank you once again -I will mark it as solved -Thank you!

  8. #8
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,649

    Re: Compare value on a range if match list linked column

    You're welcome. Glad I could help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 03-28-2015, 12:59 PM
  2. [SOLVED] Compare two names list and compare other column aftrerwards
    By badboynads in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-25-2013, 12:46 PM
  3. Compare list for Exact Match
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-04-2013, 01:59 PM
  4. Replies: 6
    Last Post: 05-30-2012, 03:09 PM
  5. list box fill range to be taken from dynamic column heading match
    By kuraitori in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-30-2009, 12:45 PM

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