Thanks for the help Hui - it worked great. On one of the spreadsheets the numbers were formatted as text - so no matches were found. I converted them and all works great! Thanks, there were 15000 lines of data!
Hui,
Thanks for the reply; I tried the formula and received a #N/A. I think there should be an IF command to match if Column A in Sheet 1 matches Column A in Sheet 2 to then bring the value for Column C in that Row on Sheet 2 into the newly "merged" Column C into Sheet 1. I am having a hard...
Hi all,
I searched the forum, but could not find a solution for my problem. Any help is appreciated. I have one spreadsheet with Data A and Data B, a second spreadsheet with Data A and Data C. I need to copy Data C from the second spreadsheet into the first spreadsheet for each line that...