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