+ Reply to Thread
Results 1 to 2 of 2

how to use match function to match that number and return a value?

  1. #1
    Registered User
    Join Date
    06-05-2019
    Location
    new york, usa
    MS-Off Ver
    2007
    Posts
    8

    how to use match function to match that number and return a value?

    i have column A1 to A10 and another column B1 to B10

    In my Column C1 to C10 is the value entered by customers ( from any One of A1-A10)

    If C1 = Any of A1-A10 ;(which match any A1-A10 numbers) Then D1 should pop up the Value from B1-B10 corrosponding to A1-A10

    for example C1= A5 ; then D1= B5

    for example C2= A2 ; then D2= B2

    for example C3= A10 ; then D3= B10

    .....

    this is done in excel

    please help thanks

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,612

    Re: how to use match function to match that number and return a value?

    double post: https://www.excelforum.com/excel-for...y-instead.html
    Ben Van Johnson

+ 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: 7
    Last Post: 07-13-2018, 09:25 AM
  2. Match function won't return correct row number
    By Shaffness in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-23-2016, 03:28 PM
  3. [SOLVED] Function to match text and return number in adjacent cell?
    By danoswalt in forum Excel General
    Replies: 6
    Last Post: 12-16-2014, 01:47 PM
  4. Match function to return column number for matching date errors
    By martinez77 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-07-2014, 10:39 AM
  5. INSERT/MATCH Function - can I match and return more than a single result?
    By nickwee in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-24-2014, 06:02 AM
  6. Replies: 6
    Last Post: 03-17-2014, 08:10 PM
  7. Replies: 5
    Last Post: 02-13-2014, 05:37 PM

Tags for this Thread

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