+ Reply to Thread
Results 1 to 3 of 3

Formula to return content from cell if two other cells match

  1. #1
    Registered User
    Join Date
    11-12-2020
    Location
    Dublin, Ireland
    MS-Off Ver
    Microsoft 365
    Posts
    2

    Formula to return content from cell if two other cells match

    Hi guys,

    I'm a relative newbie to formulas, so please forgive my ignorance.

    The scenario is:
    - Take a number in the cell at Sheet2!A2 and check the range in Sheet1!A2:A1250 for a match.
    - If Sheet2!A2 matches a cell in Sheet1!A2:A1250, take the value from the matching row cell in Sheet1!C2:C1250 and place the text from that match C column cell and drop it into Sheet2!C2

    I hope this makes sense?

    Any help on the appropriate formula to use would be very much appreciated!

    Thanks,
    Ally
    Last edited by groopezeah; 11-12-2020 at 10:41 AM. Reason: Fixed

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,891

    Re: Formula to return content from cell if two other cells match

    =VLOOKUP(a2,Sheet1!$A$:$C,3,FALSE)

    is probably what you want. If not, read the yellow banner (top of page) and post a sample sheet.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    11-12-2020
    Location
    Dublin, Ireland
    MS-Off Ver
    Microsoft 365
    Posts
    2

    Re: Formula to return content from cell if two other cells match

    Thanks so much for the quick help! That didn't work but it pointed me in the right direction

    This ended up working for what I needed: =LOOKUP(A2,Sheet2!A:A,Sheet2!C:C)

+ 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. [SOLVED] How to return another cells content using Index,Match with a IF/OR statement
    By billrogers184 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-20-2020, 10:54 AM
  2. Formula to return Header if cell content is 1
    By Sri.n in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-20-2020, 12:27 AM
  3. [SOLVED] Return DATA from different sheet to multiple cells based on content of one cell
    By NullSpot in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-19-2018, 06:53 PM
  4. Formula to match two cells to return another cell value.
    By OAKLEY in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-23-2017, 12:04 PM
  5. Return Cell with content - ignore blank cells
    By MacoF in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-15-2015, 04:29 AM
  6. [SOLVED] Match cell content with another file, and return the value from the next column over
    By mistert in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 09-29-2013, 07:06 PM
  7. [SOLVED] Highlight a cell if its content doesn't match another cells content
    By noxygen in forum Excel General
    Replies: 4
    Last Post: 04-12-2012, 04:36 AM

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