+ Reply to Thread
Results 1 to 20 of 20

Search one sheet for matching info to fill cells in another sheet

  1. #1
    Registered User
    Join Date
    12-04-2015
    Location
    USA
    MS-Off Ver
    Excell
    Posts
    22

    Search one sheet for matching info to fill cells in another sheet

    Activations Demo.xlsxESN List Demo.xlsx

    I'm a little confused by what I'm supposed to do to give a sample of what I'm trying to accomplish, so if I'm missing something, please let me know.

    In these files, I'm trying to Put formulas in the table "Inventory" in the Sheet "ESN List Demo" - An additional Table was added to the right of "Inventory" to explain what I'd like to accomplish.

    Thanks for any help!
    Last edited by svcellular; 12-04-2015 at 09:46 PM. Reason: Moderator Request

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Please help me with a formula

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    12-04-2015
    Location
    USA
    MS-Off Ver
    Excell
    Posts
    22

    Re: Please help me with a formula

    Fair enough. I was just ridiculed on another forum for using too much detail because "People will think you're giving a tutorial rather than seeking help," so I dumbed it down 14 levels.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Search one sheet for matching info to fill cells in another sheet

    Without meaning to push you deeper into the dog box, 1 of our rules (and this ios common or most forums) is that if you post on another forum, you are required to include the link to that other post This is so that members dont potentially waste their time answering a question that may already have beed resolved elsewhere
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Registered User
    Join Date
    12-04-2015
    Location
    USA
    MS-Off Ver
    Excell
    Posts
    22

    Re: Search one sheet for matching info to fill cells in another sheet

    Ouch. Tough crowd.

    I also posted this question here: http://www.mrexcel.com/forum/excel-q...-examples.html

    I've been working on this stupid thing all day. Had a few formulas that I thought I was close on and scrapped them entirely, because I'm pretty sure I broke my brain on this one.

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Search one sheet for matching info to fill cells in another sheet

    Cant have you breaking your brain

    Give me a few, and I will take a look for you

  7. #7
    Registered User
    Join Date
    12-04-2015
    Location
    USA
    MS-Off Ver
    Excell
    Posts
    22

    Re: Search one sheet for matching info to fill cells in another sheet

    I genuinely appreciate it. Might not hurt to look at the response I just posted on the linked thread.

  8. #8
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Search one sheet for matching info to fill cells in another sheet

    Sorry for the delay, real life called

    Not exactly sure which sheet in Activations, you need, so this is based on December....
    Try this in A1, copied down...
    =IFERROR(INDEX(Shipped!A$1:A$6,MATCH($C1,'[Activations Demo.xlsx]December'!$C$1:$C$7,0)),"")

  9. #9
    Registered User
    Join Date
    12-04-2015
    Location
    USA
    MS-Off Ver
    Excell
    Posts
    22

    Re: Search one sheet for matching info to fill cells in another sheet

    That's OK. I appreciate your help. I want it to search every table in Activations though, not a specific one.

  10. #10
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Search one sheet for matching info to fill cells in another sheet

    How many Activations tables (sheets) will there be, and why can they not all be on the same sheet?

    Is what I gave you, at least heading in the right direction?

  11. #11
    Registered User
    Join Date
    12-04-2015
    Location
    USA
    MS-Off Ver
    Excell
    Posts
    22

    Re: Search one sheet for matching info to fill cells in another sheet

    I was under the impression that the whole thing is called a sheet and the tabs were tables and for the sake of communication, I'm going to call them sheets and tabs.

    The Activation sheet contains tabs that are added each month. The cell we're referencing is actually a serial number of an item sold.

    The "Shipped" tab on the sheet we're working on is a list of serial numbers that have been received by me.

    I want the "Inventory" tab on that same sheet to check each serial number that was shipped to see if it was sold at any time on the Activations sheet.

    Serial numbers not sold would then be put in the new cell.

    That's the base formula I need. I'm pretty sure I can figure out the other cells on the new tab from that.

  12. #12
    Registered User
    Join Date
    12-04-2015
    Location
    USA
    MS-Off Ver
    Excell
    Posts
    22

    Re: Search one sheet for matching info to fill cells in another sheet

    Oh, and if it's necessary, Activation currently consists of 30 different tabs.

  13. #13
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Search one sheet for matching info to fill cells in another sheet

    Quote Originally Posted by svcellular View Post
    I was under the impression that the whole thing is called a sheet and the tabs were tables and for the sake of communication, I'm going to call them sheets and tabs.
    A file is called a workbook
    A workbook contains tabs or sheets (sheets is the more common term)
    A table would be a series of columns and rows used to depict info


    Are your serial numbers unique, if so can they all be on the same sheet? This will make searching through all the months much simpler

  14. #14
    Registered User
    Join Date
    12-04-2015
    Location
    USA
    MS-Off Ver
    Excell
    Posts
    22

    Re: Search one sheet for matching info to fill cells in another sheet

    If there's a way to make a reference sheet for them all to be copied into, that would be OK. The problem is that each month also has formulas necessary for monthly tracking. Do you mind if I copy the actual sheets and remove all personal customer information and send you what I'm actually working with in PM so you can see the whole scope?

  15. #15
    Registered User
    Join Date
    12-04-2015
    Location
    USA
    MS-Off Ver
    Excell
    Posts
    22

    Re: Search one sheet for matching info to fill cells in another sheet

    Or I could share the copies to your gmail to view on google sheets for that matter.

  16. #16
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Search one sheet for matching info to fill cells in another sheet

    Cant send in PM, if you really don't want to share here, let me know and I will send you my email in PM (not wise to share info like that in a public forum)

  17. #17
    Registered User
    Join Date
    12-04-2015
    Location
    USA
    MS-Off Ver
    Excell
    Posts
    22

    Re: Search one sheet for matching info to fill cells in another sheet

    If you use google sheets, you can PM me your gmail address, and I can share the copies to you.

  18. #18
    Registered User
    Join Date
    12-04-2015
    Location
    USA
    MS-Off Ver
    Excell
    Posts
    22

    Re: Search one sheet for matching info to fill cells in another sheet

    I can of course also email. Just thought that might be easier.

  19. #19
    Registered User
    Join Date
    12-04-2015
    Location
    USA
    MS-Off Ver
    Excell
    Posts
    22

    Re: Search one sheet for matching info to fill cells in another sheet

    I still have no formula for this if anyone can be of any help. Willing to share a Google Sheets file if that helps.

  20. #20
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Search one sheet for matching info to fill cells in another sheet

    See if this will get us started?
    ESN List workbook - In Inventory sheet - A2...
    =IF(ISERROR(INDEX('[Copy of Sterling Activations-Upgrades.xlsx]December'!$A$3:$A$26,MATCH(Shipped!$G3,'[Copy of Sterling Activations-Upgrades.xlsx]December'!$D$3:$D$26,0))),Shipped!A3,"")
    copied down

+ 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: 11
    Last Post: 06-06-2014, 03:34 PM
  2. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 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