Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging spreadsheet data
I have one spreadsheet with data and another spreadsheet with different data.
What I would like to do is get the columns from Spreadsheet 2 into Spreadsheet 1 when the column 'Service Tag" is equal between the two. Will VLOOKUP provide me this function??? Or is there an easier way to do this within Excel??? Any help is greatly appreciated and Thanks in advance. wnfisba |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging spreadsheet data
VLOOKUP would be an excellent way of doing this. The only limitation is that the lookup column must be the leftmost column of the table. If it isn't you can create an extra column on the left and link by = formula. -- mrice Research Scientist with many years of spreadsheet development experience ------------------------------------------------------------------------ mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931 View this thread: http://www.excelforum.com/showthread...hreadid=545951 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing data, then adding data to the new spreadsheet.. a conund | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
merging and formating data | New Users to Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |