Your Ad Here Your Ad Here
Results 1 to 5 of 5

Thread: Excel question

  1. #1

    Arrow

    I have a customer database filled with names, addresses, identification numbers, and identification type.
    In Microsoft Excel 2007, is it possible to be in a different tab, type the customers name into a cell, and have the info of the specified related cells displayed?
    Any help on doing this would be appreciated.
    Q6600 @ 3.42Ghz | Gigabyte EP35-DS3R | EVGA 8800GT 721/1802/2006 w/ Accelero S1 | 4gb Crucial DDR2 @ 760mhz | 750gb Hitachi 7k1000 | Corsair 520HX | 2 x Samsung SyncMaster T240 24" | Windows 7 Ultimate

  2. Software & Hardware   -   #2
    BANNED
    Join Date
    Jul 2009
    Posts
    452
    yep, use vlookup/hlookup.

  3. Software & Hardware   -   #3
    Ac3Dunk's Avatar S.O.P-Laf BT Rep: +5
    Join Date
    Aug 2006
    Location
    Sou.MaNTa-EC
    Posts
    758
    Vlookup is your best choice, you can also try pivot table.
    #zEdit; FST is bad, it's like drugs. Mkay?

  4. Software & Hardware   -   #4
    lightshow's Avatar Asleep at the wheel
    Join Date
    Mar 2003
    Age
    32
    Posts
    924
    You may want to also look into some VB macro code if you want to do more in depth searching across sheets
    I miss the days of random nut '03
    Click for more activation options, then activate by telephone. Run the keygen.
    if I call them, aren't they going to get me? (you know, down there)

  5. Software & Hardware   -   #5
    Thanks everyone.
    I seem to have run into an issue while using VLOOKUP.
    Here is the situation:
    The "Customers" Tab has the last names in column A, first names in column B, ID number in column C and ID Type in column D.

    In another tab, I want to be able to type the customers full name and get the ID number inputted into the cell below.
    So my formula looks something like this:
    =VLOOKUP(H2,Customers!A3:R1000,13,FALSE)
    *H2 being the field where you type the customers name, and 13 being the column C.

    The issue is that I can only search either last or first name which is not specific enough. I need to be able to input "John A Smith" or "John Smith" and come out with the corresponding number in column C.

    Is this possible?
    Thank you very much for the help so far.
    Q6600 @ 3.42Ghz | Gigabyte EP35-DS3R | EVGA 8800GT 721/1802/2006 w/ Accelero S1 | 4gb Crucial DDR2 @ 760mhz | 750gb Hitachi 7k1000 | Corsair 520HX | 2 x Samsung SyncMaster T240 24" | Windows 7 Ultimate

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
  •