+ Reply to Thread
Results 1 to 6 of 6

Need a formula to copy the contents of a cell if two cells match.

Hybrid View

  1. #1
    Registered User
    Join Date
    12-05-2014
    Location
    Manchester
    MS-Off Ver
    2007
    Posts
    45

    Need a formula to copy the contents of a cell if two cells match.

    Hi all

    I've attached an example of a sheet I need some help with please.

    If A3 (product name) and C3 (date) match the cells in columns G-L, then I want cell B3 to copy the data.

    I've given an example in B2.

    Any help would be appreciated.
    Attached Files Attached Files

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,937

    Re: Need a formula to copy the contents of a cell if two cells match.

    =index($h$2:$l$3,match($a2,$g$2:$g$3,0),match($c2,$h$1:$l$1))
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Valued Forum Contributor Kamboj's Avatar
    Join Date
    09-25-2014
    Location
    India
    MS-Off Ver
    2003 - 2010
    Posts
    430

    Re: Need a formula to copy the contents of a cell if two cells match.

    =index($g$1:$l$3,match(a2,$g$1:$g$3,0),match(c2,$h$1:$l$1,0)+1)

  4. #4
    Registered User
    Join Date
    12-05-2014
    Location
    Manchester
    MS-Off Ver
    2007
    Posts
    45

    Re: Need a formula to copy the contents of a cell if two cells match.

    Thanks but I don't think either of these work? Whenever I put in the formula, it gives the wrong price. For example, if I use the formula in B3, it gives a price of 1.533 but it should actually give 1.632 (cell K3).

  5. #5
    Valued Forum Contributor Kamboj's Avatar
    Join Date
    09-25-2014
    Location
    India
    MS-Off Ver
    2003 - 2010
    Posts
    430

    Re: Need a formula to copy the contents of a cell if two cells match.

    These both formulas are ok you have to paste this in B2 and then fill down

  6. #6
    Registered User
    Join Date
    12-05-2014
    Location
    Manchester
    MS-Off Ver
    2007
    Posts
    45

    Re: Need a formula to copy the contents of a cell if two cells match.

    Thank you.

+ 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. Need a formula to copy the contents of a cell if two cells match.
    By eekbubble in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-03-2015, 09:16 AM
  2. Match 2 cells on 2 worksheets and copy contents of another cell
    By granitetek in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-03-2014, 03:03 PM
  3. Excel copy cell contents if two dates match
    By mrwalters in forum Excel General
    Replies: 3
    Last Post: 01-01-2013, 01:26 PM
  4. Copy If Match a cell contents
    By rmharrison in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-11-2012, 07:48 PM
  5. Replies: 6
    Last Post: 12-07-2012, 05:38 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