Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 02-03-2013, 08:42 AM
Cardinal2 Cardinal2 is offline Lookup Macro Windows 7 64bit Lookup Macro Office 2007
Novice
Lookup Macro
 
Join Date: Feb 2013
Posts: 10
Cardinal2 is on a distinguished road
Default Lookup Macro

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
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Lookup angie.chang Excel 1 07-27-2012 09:45 PM
Lookup Macro Possible Lookup Karen222 Excel 3 01-10-2012 05:41 AM
Lookup Macro LookUp aztiguen24 Excel 5 05-24-2011 03:57 AM
Multi-Variable Lookup help ebolton Excel 8 05-05-2011 05:28 AM
Lookup Macro Using the LOOKUP Command Grapejuice Excel 2 10-15-2008 02:02 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:02 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft