Filter -merge?

Tap · May 21st, 2002, 02:06 PM

I have data in 2 spreadsheets that I want to put together but Im having difficulty
what I ahve is something like
File 1:
ID Name
123 John
234 Jim
456 Mary
678 Jane
890 Bill

File2:
ID Item
123 Chips
123 snacks
123 Chocs
234 biscuits
234 cakes

what I want is ID Name and Item on one sheet
so I would like to have have:
ID Name Item
123 John Chips
123 John snacks
123 John Chocs
234 Jim biscuits
234 Jim cakes

This is obviously only an example, but I have a couple of thousand records

I have tried filtering and merging but no joy.
Can anyone help

Thanks

Asala42 · May 21st, 2002, 02:24 PM

Hey,

I suspect the easiest approach would be a VLOOKUP on one of the sheets.

Adam

Tap · May 21st, 2002, 02:36 PM

Sound good - I looked it upon help but didn't fuly understand

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 21st, 2002, 02:06 PM	#1
Tap New Member Join Date: Feb 2002 Posts: 14	I have data in 2 spreadsheets that I want to put together but Im having difficulty what I ahve is something like File 1: ID Name 123 John 234 Jim 456 Mary 678 Jane 890 Bill File2: ID Item 123 Chips 123 snacks 123 Chocs 234 biscuits 234 cakes what I want is ID Name and Item on one sheet so I would like to have have: ID Name Item 123 John Chips 123 John snacks 123 John Chocs 234 Jim biscuits 234 Jim cakes This is obviously only an example, but I have a couple of thousand records I have tried filtering and merging but no joy. Can anyone help Thanks

May 21st, 2002, 02:24 PM	#2
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,030	Hey, I suspect the easiest approach would be a VLOOKUP on one of the sheets. Adam

May 21st, 2002, 02:36 PM	#3
Tap New Member Join Date: Feb 2002 Posts: 14	Sound good - I looked it upon help but didn't fuly understand