Page 1 of 2 12 LastLast
Results 1 to 15 of 22

Thread: Excel Help

  1. #1
    Addict
    Points: 72,291, Level: 83
    Level completed: 50%, Points required for next Level: 859
    Overall activity: 13.0%
    Achievements:
    Social50000 Experience PointsRecommendation Second ClassVeteran
    NATEizKING's Avatar
    Join Date
    Feb 2011
    Location
    Hilton
    Posts
    6,588
    Points
    72,291
    Level
    83
    Thumbs Up
    Received: 161
    Given: 150

    Excel Help

    Been since my high school days since I've done much with Excel other than that introductory class at ISU with Word, Excel, Access, and Powerpoint.

    I am trying to get a table of fees from sheet2 to coincide with a cell in sheet1 so when I type in a label from sheet2 it will automatically include the fee in sheet1. Sheet2 has a table which has the name of the fee in column A and the fee in column B. I want to take this table from sheet2 and make it so when I type in a name in sheet1 it will automatically include the fee. Thanks ahead of time for the help, I hope I was clear enough in my explanation.



  2. #2
    Hall-Of-Famer
    Points: 69,074, Level: 81
    Level completed: 61%, Points required for next Level: 676
    Overall activity: 13.0%
    Achievements:
    Veteran50000 Experience Points
    Jordanj6502's Avatar
    Join Date
    Jan 2010
    Location
    Ames
    Posts
    3,669
    Points
    69,074
    Level
    81
    Thumbs Up
    Received: 51
    Given: 19

    Re: Excel Help

    MS Excel: Lookup Function

    Is this what you are trying to do?



  3. #3
    Addict
    Points: 201,698, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 13.0%
    Achievements:
    50000 Experience PointsVeteran
    longtimeclone's Avatar
    Join Date
    Dec 2009
    Location
    Up north
    Posts
    7,693
    Points
    201,698
    Level
    100
    Thumbs Up
    Received: 53
    Given: 26

    Re: Excel Help

    I was going to suggest a vlookup

    MS Excel: VLookup Function



  4. #4
    Addict
    Points: 72,291, Level: 83
    Level completed: 50%, Points required for next Level: 859
    Overall activity: 13.0%
    Achievements:
    Social50000 Experience PointsRecommendation Second ClassVeteran
    NATEizKING's Avatar
    Join Date
    Feb 2011
    Location
    Hilton
    Posts
    6,588
    Points
    72,291
    Level
    83
    Thumbs Up
    Received: 161
    Given: 150

    Re: Excel Help

    Quote Originally Posted by Jordanj6502 View Post
    MS Excel: Lookup Function

    Is this what you are trying to do?
    That's on the right track though I'm not sure how to get it to work properly. I'll simplify what I was trying to explain.

    Sheet2 I made a table: Column A is the Fee Name and Column B is the Fee.

    Sheet1 I have a chart: Column A I type in the Fee Name from Sheet2 and want the corresponding Fee from Sheet2 to appear in Column B.



  5. #5
    Hall-Of-Famer
    Points: 69,074, Level: 81
    Level completed: 61%, Points required for next Level: 676
    Overall activity: 13.0%
    Achievements:
    Veteran50000 Experience Points
    Jordanj6502's Avatar
    Join Date
    Jan 2010
    Location
    Ames
    Posts
    3,669
    Points
    69,074
    Level
    81
    Thumbs Up
    Received: 51
    Given: 19

    Re: Excel Help

    So you need to know how to reference between sheets.. give me a sec and I can look that up.



  6. #6
    Speechless
    Points: 856,842, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 64.0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience PointsOverdrive
    CycloneErik's Avatar
    Join Date
    Jan 2008
    Location
    Jamerica
    Posts
    55,038
    Points
    856,842
    Level
    100
    Thumbs Up
    Received: 1,284
    Given: 1,115

    Re: Excel Help

    Are you just importing a total from a cell on one sheet to another sheet?

    If so, that's easy. Either jordan or IcSyU showed me how. Well, it's easy now.


    Since we are an elite team now, let's go get that One Cyclone Moment.
    Make this one for the ages!




    http://rememberingdoria.wordpress.com/

  7. #7
    Addict
    Points: 201,698, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 13.0%
    Achievements:
    50000 Experience PointsVeteran
    longtimeclone's Avatar
    Join Date
    Dec 2009
    Location
    Up north
    Posts
    7,693
    Points
    201,698
    Level
    100
    Thumbs Up
    Received: 53
    Given: 26

    Re: Excel Help

    Yeah I am pretty sure that a vlookup formula will work then. You should be able to put the formula in second column so if you type in the name from column A it should fill.


    vlookup(column A value of Sheet 1, table from sheet 2, column number with the fee, type "false")

    Also when you do the table from sheet 2 make sure you hit f4 to make it so the entire table is always selected.


    Last edited by longtimeclone; 05-10-2012 at 11:02 PM.

  8. #8
    Hall-Of-Famer
    Points: 69,074, Level: 81
    Level completed: 61%, Points required for next Level: 676
    Overall activity: 13.0%
    Achievements:
    Veteran50000 Experience Points
    Jordanj6502's Avatar
    Join Date
    Jan 2010
    Location
    Ames
    Posts
    3,669
    Points
    69,074
    Level
    81
    Thumbs Up
    Received: 51
    Given: 19

    Re: Excel Help

    Problem may be that it doesn't work in an unsorted list... I have to take a little bit more time to figure this out...



  9. #9
    Addict
    Points: 72,291, Level: 83
    Level completed: 50%, Points required for next Level: 859
    Overall activity: 13.0%
    Achievements:
    Social50000 Experience PointsRecommendation Second ClassVeteran
    NATEizKING's Avatar
    Join Date
    Feb 2011
    Location
    Hilton
    Posts
    6,588
    Points
    72,291
    Level
    83
    Thumbs Up
    Received: 161
    Given: 150

    Re: Excel Help

    Quote Originally Posted by longtimeclone View Post
    Yeah I am pretty sure that a vlookup formula will work then. You should be able to put the formula in second column so if you type in the name from column A it should fill.


    vlookup(column A value of Sheet 1, table from sheet 2, column number with the fee, type "false")
    I understand the cell in sheet1 column B ---> =VLOOKUP(ColumnA value of Sheet1,...)

    How do I get the table for the second part of that? Copy paste the entire table?



  10. #10
    Addict
    Points: 72,291, Level: 83
    Level completed: 50%, Points required for next Level: 859
    Overall activity: 13.0%
    Achievements:
    Social50000 Experience PointsRecommendation Second ClassVeteran
    NATEizKING's Avatar
    Join Date
    Feb 2011
    Location
    Hilton
    Posts
    6,588
    Points
    72,291
    Level
    83
    Thumbs Up
    Received: 161
    Given: 150

    Re: Excel Help

    Quote Originally Posted by Jordanj6502 View Post
    Problem may be that it doesn't work in an unsorted list... I have to take a little bit more time to figure this out...
    Not in a major rush with it just trying to save some time for the future.



  11. #11
    Hall-Of-Famer
    Points: 69,074, Level: 81
    Level completed: 61%, Points required for next Level: 676
    Overall activity: 13.0%
    Achievements:
    Veteran50000 Experience Points
    Jordanj6502's Avatar
    Join Date
    Jan 2010
    Location
    Ames
    Posts
    3,669
    Points
    69,074
    Level
    81
    Thumbs Up
    Received: 51
    Given: 19

    Re: Excel Help

    =VLOOKUP(Sheet1!A1,Sheet2!$A$1:$B$5,2,0)

    So Sheet1! means the sheet1 A1 being a reference to the name you typed, the Sheet2!$A$1:$B$5 is the whole table from top left (A1) to bottom right (B5), the 2 is the column with the fee, and 0/False are the same.

    The $ in the table makes it static, so you can drag the formula around and still reference the same table.



  12. #12
    Addict
    Points: 201,698, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 13.0%
    Achievements:
    50000 Experience PointsVeteran
    longtimeclone's Avatar
    Join Date
    Dec 2009
    Location
    Up north
    Posts
    7,693
    Points
    201,698
    Level
    100
    Thumbs Up
    Received: 53
    Given: 26

    Re: Excel Help

    When you are putting the formula in you should be able to immediately go to the tab and select the entire table.

    When you have it all selected make sure you hit f4 which will make it so the entire table is always selected otherwise if you drag the formula down it will move the table selection down as well.



  13. #13
    Addict
    Points: 72,291, Level: 83
    Level completed: 50%, Points required for next Level: 859
    Overall activity: 13.0%
    Achievements:
    Social50000 Experience PointsRecommendation Second ClassVeteran
    NATEizKING's Avatar
    Join Date
    Feb 2011
    Location
    Hilton
    Posts
    6,588
    Points
    72,291
    Level
    83
    Thumbs Up
    Received: 161
    Given: 150

    Re: Excel Help

    Quote Originally Posted by CycloneErik View Post
    Are you just importing a total from a cell on one sheet to another sheet?

    If so, that's easy. Either jordan or IcSyU showed me how. Well, it's easy now.
    I need sheet1 user input in Column A to correspond to sheet2 Column A data, get data value from sheet 2 Column B, and return that value to sheet1 Column B.



  14. #14
    Speechless
    Points: 856,842, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 64.0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience PointsOverdrive
    CycloneErik's Avatar
    Join Date
    Jan 2008
    Location
    Jamerica
    Posts
    55,038
    Points
    856,842
    Level
    100
    Thumbs Up
    Received: 1,284
    Given: 1,115

    Re: Excel Help

    I just use =pagename!cell#

    For example =Attendance!E3

    I don't know if that would work for you or not. Someone showed it to me, and it's perfect for the little bit I do.


    Since we are an elite team now, let's go get that One Cyclone Moment.
    Make this one for the ages!




    http://rememberingdoria.wordpress.com/

  15. #15
    Addict
    Points: 72,291, Level: 83
    Level completed: 50%, Points required for next Level: 859
    Overall activity: 13.0%
    Achievements:
    Social50000 Experience PointsRecommendation Second ClassVeteran
    NATEizKING's Avatar
    Join Date
    Feb 2011
    Location
    Hilton
    Posts
    6,588
    Points
    72,291
    Level
    83
    Thumbs Up
    Received: 161
    Given: 150

    Re: Excel Help

    Quote Originally Posted by Jordanj6502 View Post
    =VLOOKUP(Sheet1!A1,Sheet2!$A$1:$B$5,2,0)

    So Sheet1! means the sheet1 A1 being a reference to the name you typed, the Sheet2!$A$1:$B$5 is the whole table from top left (A1) to bottom right (B5), the 2 is the column with the fee, and 0/False are the same.

    The $ in the table makes it static, so you can drag the formula around and still reference the same table.

    Here is what I'm currently at but it just returns #VALUE:

    =VLOOKUP(Invoice!C10,Fee!$A$2:$B$62,Invoice!F10,FALSE)



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
  • Football
  • Iowa State vs. North Dakota State
  • August 30, 2014
  • 11:00 AM