Results 1 to 4 of 4

Loolkup Item # in a data range and return text from another cell in row.

Threaded View

  1. #1
    Registered User
    Join Date
    01-13-2011
    Location
    Joplin, MO
    MS-Off Ver
    Excel 2003
    Posts
    12

    Loolkup Item # in a data range and return text from another cell in row.

    I know I will kick myself for this but I have struggled with this for a while now. I am not that great in vlookup or even if that is what I need to do.

    Here is what I am looking to do: ( i have attached the example as a file also!)

    DATA TAB = Long list of info data to work from


    Name Address 1 City State Zip Tech
    1005 XXXXXX XXXXXX XXXXXX XXXXXX Bob
    1012 XXXXXX XXXXXX XXXXXX XXXXXX Gary
    1036 XXXXXX XXXXXX XXXXXX XXXXXX John
    1050 XXXXXX XXXXXX XXXXXX XXXXXX Dave
    1060 XXXXXX XXXXXX XXXXXX XXXXXX Mike
    1070 XXXXXX XXXXXX XXXXXX XXXXXX Lonnie
    1080 XXXXXX XXXXXX XXXXXX XXXXXX Bob
    1090 XXXXXX XXXXXX XXXXXX XXXXXX Gary
    1101 XXXXXX XXXXXX XXXXXX XXXXXX John
    1102 XXXXXX XXXXXX XXXXXX XXXXXX Dave
    1103 XXXXXX XXXXXX XXXXXX XXXXXX Mike
    1104 XXXXXX XXXXXX XXXXXX XXXXXX Lonnie
    1106 XXXXXX XXXXXX XXXXXX XXXXXX Bob

    LOOKUP TAB = List of unique items that I need to find out the tech.

    Item # Tech
    1005 ?
    1012 ?
    1070 ?
    1080 ?
    1104 ?
    1106 ?
    1107 ?
    1111 ?
    1119 ?
    1182 ?
    1198 ?
    1200 ?
    1304 ?

    I just nned to have a formula that I can copy down the list where TECH is so that it finds the item and returns the TECH info.

    Any help will be greatly appreciated.
    Attached Files Attached Files

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