Hi All,
I am looking for an Excel macro to search for value in one spreadsheet column from a table in another spreadsheet and if found, replace it with the corresponding value.
Spreadsheet 1
column 1 Column2
1 a
2 b
Spreadsheet 2
1
2
Spreadsheet2 after running macro
a
b
Thanks,
Mark
put data in columns A B starting from row 2
Please Login or Register to view this content.
Last edited by patel45; 10-03-2012 at 01:06 PM.
If solved remember to mark Thread as solved
Hi, Mark,
you could use WorksheetFunction.VLookUp for doing so (with that small example given IŽd rely on a Formula instead of VBA).
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks