+ Reply to Thread
Results 1 to 2 of 2

Compare value on a range if it match list number Please help newbie

Hybrid View

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

    Compare value on a range if it match list number Please help newbie

    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
    Last edited by ricklou; 03-28-2015 at 12:56 PM.

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

    Re: Compare value on a range if it match list number Please help newbie

    Apologies can a admin move this to formula its posted in wrong area

+ 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. Compare/Match values by certain criteria (Vendor Number and System)
    By Alx77 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-10-2013, 02:01 PM
  2. Compare list for Exact Match
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-04-2013, 01:59 PM
  3. [SOLVED] Compare a range for a match and then put it in a cell
    By Zoomer36 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-23-2012, 04:24 PM
  4. Replies: 6
    Last Post: 05-30-2012, 03:09 PM
  5. How can I compare a number against a list of numbers
    By johnny in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-22-2005, 04:06 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