+ Reply to Thread
Results 1 to 3 of 3

Lookup in a different sheet

  1. #1
    Registered User
    Join Date
    12-15-2011
    Location
    Dallas, Tx
    MS-Off Ver
    Excel 2010
    Posts
    1

    Lookup in a different sheet

    Hi,

    I am building quicker way to invoice my clients and I was hoping to do something like this.

    I want to be able to enter an account number for the client that I am billing and have all of their information from a different sheet auto fill in different cells.


    for example:
    |____________A________________ |___________B_________________________|
    1| ______Account Number__________ | 02354 (I would enter this manually)______|
    2|______________________________ |_____________________________________|
    3|_______Address_________________| 123 Maple Street (auto filled from sheet 2) |
    4|_______Amount Due:_____________| $500 (auto filled from sheet 2)___________|
    5|_______Due By:_________________| 01/01/2012 ___________________________|
    6|_______________________________|_____________________________________|


    I hope this is clear. Let me know if you have any suggestions.

    Thanks,

    John James III

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902

    Re: Lookup in a different sheet

    Have a look at VLOOKUP help in Excel's help files...

    You just need to have a table listing the account numbers with all relevant info in the adjacent rows, then use VLOOKUP to extract based on the account number.

    e.g.

    =VLOOKUP(A1,'Data Sheet'!$A:$F,2,0) extracts from column B of sheet called Data Sheet, where a match is found in column A corresponding to Acct No in A1 of Invoice sheet.
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,343

    Re: Lookup in a different sheet

    Hi,

    Name your sheet 2 table of data comprising the four columns (and maybe others) for account number,address, due amount and due by, say "Data" and then just use a standard VLOOKUP() function. e.g. for the address

    Please Login or Register  to view this content.
    Regards
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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