+ Reply to Thread
Results 1 to 4 of 4

Show the value from cells when they're the same and have the same id numbers...

  1. #1
    Registered User
    Join Date
    09-09-2022
    Location
    Los Angeles, USA
    MS-Off Ver
    MSOFFICE 365
    Posts
    2

    Question Show the value from cells when they're the same and have the same id numbers...

    Hello there,
    can You guys help me to find a way to show the values from the cells with some conditions?
    Below the excel matrix.

    I want to show the status2 in status1 when values1 = values2 where index cells are the same for products "THIS" and values2

    Untitled.png

  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
    44,139

    Re: Show the value from cells when they're the same and have the same id numbers...

    Hi there.

    A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

    Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.

    Please update your profile to show your Excel version. File/Account:
    Attached Images Attached Images
    Last edited by Glenn Kennedy; 09-09-2022 at 04:49 AM. Reason: I accidentally posted my email address.
    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

  3. #3
    Registered User
    Join Date
    09-09-2022
    Location
    Los Angeles, USA
    MS-Off Ver
    MSOFFICE 365
    Posts
    2

    Re: Show the value from cells when they're the same and have the same id numbers...

    My MS-Office is the same as Yours.
    My question is clearly described above.

  4. #4
    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
    44,139

    Re: Show the value from cells when they're the same and have the same id numbers...

    Thanks for updating your profile, However, I do not plan to retype/recreate what you have in front of you. That's why I asked for an Excel sheet, rather than a picture of one.

    Others may help, but I'm out.

+ 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: 3
    Last Post: 02-06-2019, 01:36 PM
  2. [SOLVED] How to show common value of 2 sets of numbers in 2 cells?
    By london7871 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-15-2018, 11:51 PM
  3. Counting cells if both columns show matching ref numbers.
    By dandavis1 in forum Excel General
    Replies: 2
    Last Post: 05-28-2012, 08:45 AM
  4. format cells not to show minus numbers and replace with zero
    By troysie in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-18-2011, 04:55 AM
  5. Help with code to show all cells with that contain 5 numbers
    By dcgrove in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-21-2010, 05:25 PM
  6. [SOLVED] How do I show break in bar graph to show large and small numbers
    By GK in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-19-2005, 04:25 PM
  7. [SOLVED] How do I show break in bar graph to show large and small numbers
    By GK in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 12-19-2005, 02:40 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