![]() |
#1
|
|||
|
|||
![]()
I would like help if possible in making a lookup Macro activated by a button in data spreadsheet.
I have a data sheet that has Column R=has data, Column S has more data and Column T has an address contains mixed number and letter eg r1 = hdlp, s1 = blue, t1 = 19:33:b8 r2 = can, s2 = green , t2 = 19:44:b5 these 3 data rows go on for about 400 rows. I copy my lookup sheet into columns A to L, this sheet can contain 30000 or more rows The column L has a similar value found in somewhere in one of cells in column T What I would like is a macro that once activated would go to the first value in row1 of column L find the exact match in row t and insert the corresponding value in colums R1 and S1, then go to the next row in column L and repeat the same process until all the values in Column L has their correspoing data value inserted from columns R and S into the columns M & N In the end I would have Column L,M & N look like 12:44:b5 can green and so on Any help would be appreciated Matthew |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Lookup | angie.chang | Excel | 1 | 07-27-2012 09:45 PM |
![]() |
Karen222 | Excel | 3 | 01-10-2012 05:41 AM |
![]() |
aztiguen24 | Excel | 5 | 05-24-2011 03:57 AM |
Multi-Variable Lookup help | ebolton | Excel | 8 | 05-05-2011 05:28 AM |
![]() |
Grapejuice | Excel | 2 | 10-15-2008 02:02 PM |