Philip Wong
New Member
- Joined
- Jul 13, 2006
- Messages
- 26
Hi,
I have a table of data and I am looking to copy some of that data into a range of cells, depending on the whether the data matches one other cell.
e.g.
Type Price Quantity
Hammer A £2 300
Nails B £3 500
Screwdriver C £2.50 400
Hammer ? ? ?
Nails ? ? ?
Hammer ? ? ?
From the example above I am looking to have the question marks read the data from the table, with Hammer reading the same data but wanting to read it twice as there are two entries.
Cheers,
Phil
I have a table of data and I am looking to copy some of that data into a range of cells, depending on the whether the data matches one other cell.
e.g.
Type Price Quantity
Hammer A £2 300
Nails B £3 500
Screwdriver C £2.50 400
Hammer ? ? ?
Nails ? ? ?
Hammer ? ? ?
From the example above I am looking to have the question marks read the data from the table, with Hammer reading the same data but wanting to read it twice as there are two entries.
Cheers,
Phil