Results 1 to 4 of 4

Vlookup issue

Threaded View

  1. #1
    Registered User
    Join Date
    01-26-2014
    Location
    Sacramento, CA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Vlookup issue

    Hi Guys.
    I'm having a little trouble with VLOOKUP and was hoping for a little insight. Basically I am working on a spreadsheet for work that will search through a column for text matches (Column A) and display their corresponding wire numbers (Column B) in various columns based on the text found.

    Column A is a list of Device Tags. Column B is Column A's corresponding wire number. Column H-L will be used to display sorted lists based on the values in Column A. I have Column A set as Array INAMES and Column B set as Array IWIRES.

    The problem I am running into is that after the first VLOOKUP result I hit a snag. I found another function example that allowed me to display the second and third result with offset, but this led to me having to continue to manipulate the offset value in the function, and I would prefer to not have to edit these functions every time a new spreadsheet needs to be created.

    As an Example, here are a few lines of data:

    P1.SE1.EPB 1508.02 START STOP E-STOP
    P1.SE2.EPB 1508.03 1508.04 1508.06 1508.02
    P1.SE1.SRPB 1508.04 1508.05 1508.07 1508.03
    P1.SE2.SRPB 1508.05 1508.09 1508.08
    P1.SE1.STPB 1508.06
    P1.SE2.STPB 1508.07
    P2.SE1.EPB 1508.08
    P2.SE1.SRPB 1508.09

    What I want is for the values in Column A that contain "SRPB" to place the corresponding wire number in the "Start" column. "STPB" in the Stop Column. "EPB" in the E-STOP column, etc.

    If anyone can shed any light on this subject it would be greatly appreciated. I've attached an example spreadsheet. My current attempts at vlookup are located in the Start column.

    Thank you in advance,

    Justin
    Attached Files Attached Files
    Last edited by oNiGHTo; 03-13-2014 at 11:29 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. vlookup issue
    By roelofB2014 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-08-2014, 09:57 AM
  2. [SOLVED] VLookUp issue
    By lionlunatication in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-20-2013, 09:33 PM
  3. Vlookup issue
    By ln1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-03-2012, 10:54 AM
  4. vlookup issue
    By ascottbag in forum Excel General
    Replies: 8
    Last Post: 02-13-2011, 03:53 PM
  5. Vlookup Issue
    By JK1234 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-13-2008, 10:34 AM

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