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
Bookmarks