+ Reply to Thread
Results 1 to 7 of 7

Retrieving information from other sheets

  1. #1
    Registered User
    Join Date
    07-18-2012
    Location
    Alaska
    MS-Off Ver
    Excel 2007
    Posts
    4

    Retrieving information from other sheets

    Hello,
    My name is Zach and im new to the forum, don't use excel very much but I find myself needing it to create something for my workplace. I will try my best to explain what im trying to do and see if its possible.

    I have a report at work that I have the option of exporting to excel and im trying to make another sheet in the same workbook get values from this report.

    Inv # Description Measure Monday Tuesday Wednesday Thursday Friday Saturday Sunday Total Multiplier Label Total

    40001 HAMBURGER 4:1 PATTY PATT 65 94 88 118 85 83 56 589 80 CASE 7.36
    40003 BACON STRIPS BAG 0.8 1.3 1.06 1.76 1.36 1.26 0.68 8.22 3 CASE 2.74

    That is how the lines show up, my problem is that based on whether I have new inventory items etc, the order of the items in the list can change drastically, and the only value im trying to retrieve for each item is the last value, Total. What I was previously doing was just going to the cell were I need the value, hitting "=" then clicking on the previous sheet and the cell that had the total imformation. If something on the list changes though then that will be pulling up the wrong value... Is there a way to tell a cell to go to the previous sheet, search for say the Inv #, then somehow return the last value on that row? Which would be the value under the "total" column...

    Hopefully I explained this decently lol, anything anyone could help me with would be much appreciated!
    -Zach

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Retrieving information from other sheets

    Hi and welcome to the forum.

    I believe that we can do this, but will be better for all if you will upload a small sample workbook to work on it.

    "To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button."
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Registered User
    Join Date
    07-18-2012
    Location
    Alaska
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Retrieving information from other sheets

    theoretical.xls

    Alright, I believe I uploaded it correctly. What i'm trying to do is get the imformation from the total line on the Theoretical sheet onto the usage line that corresponds with the item on the order sheet. The order sheet is organized the way I have to actually do my order and the way I have to input it when I place it online, which is why I dont want to just the math that I have to the side on the theoretical sheet.

    Thanks again! If anyone figures out how to do it, i'm very good at following directions and would be perfectly able to complete it if I know how its done!

  4. #4
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Retrieving information from other sheets

    The description of the items in 2 sheets, is different.....

    Why in OrderSheet!F3, is equal(=) TheoriicalO46??

  5. #5
    Registered User
    Join Date
    07-18-2012
    Location
    Alaska
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Retrieving information from other sheets

    The descriptions are different but its the same item, the company I order product from lists things differently then the way they are listed in my computers inventory. I just need to figure out how to get say F3 on order sheet to search the other sheet for "40056" and return the value listed last on that row or something... I'm sorry this is hard to explain =/

  6. #6
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Retrieving information from other sheets

    I am sorry but there is nothing common in your sheets so to compare them....

    But If you want, for example, to get the content of N46, using F3 value, try this

    =INDEX(Theoretical!$N$10:$N$234,MATCH(F3,Theoretical!$O$10:$O$234,0))

    Or else, you have to wait. Maybe someone else, has a better idea.

  7. #7
    Registered User
    Join Date
    07-18-2012
    Location
    Alaska
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Retrieving information from other sheets

    While that wasnt quite what im looking for I appreciate the effort! I'm just trying to make it so that if a new item is added to the Theoretical report, the other sheet still pulls the correct values for each items usage

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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