| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to merge worksheets on a key - merge horizontally, that is
Watch your typing <bg.
=VLOOKUP(A1,sheet1:A:B,1,FALSE) should be =VLOOKUP(A1,sheet1!A:B,2,FALSE) or =VLOOKUP(A1,'sheet 1'!A:B,2,FALSE) (single quotes maybe required depending on the name of that sheet) And you want that 3rd parm to be 2--you're bringing back the value in the second column in that range (A:B on sheet1). wrote: In Sheet 2, Column C I add the formula: =VLOOKUP(A1,sheet1:A:B,1,FALSE) This results in #NAME? Is there a solution that doesn't require drag-filling? -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| merge two excel files like in word mail merge | Excel Discussion (Misc queries) | |||
| Zip codes in mail merge - first digit doesn't display in merge | Excel Discussion (Misc queries) | |||
| mail merge excludes my headers and critical data in Word merge | Excel Discussion (Misc queries) | |||
| Merge =( formula should retain fraction type numbers after merge. | Excel Worksheet Functions | |||
| how do i get my mail merge to update the data source at each merge | Excel Discussion (Misc queries) | |||
Threaded Mode
