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

Hi
Can you post a sample and I will take a look for you later this evening.
Tony

Hi OPM, here is my question in a slightly changed manner.

I would like help in writing VBA for a Macro activated by a control button in my spreadsheet.
The spreadsheet has mixed number and letter entries in column L eg. 19:44:B5
I will paste onto the sheet, 3 additional columns R,S and T, these columns
Will have about 400 rows. One cell in column R will have the matching cell value
As listed above for Column L eg 19:44:B5
I would select a cell in Column L and activate the Macro. The Macro would search
The 400 rows in column R and once it located the matching data in the cell in Column R
Would copy the matching data next to the selected cell in Column L and also copy the
Additional data that is in Column S and T that are next to
In the end I would have Column L,R,S and T would look like
19:44:B5, 19:44:b5, data,data
Any help would be appreciated
Matthew