Formula required

[Philip Wong]

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

 

[Peter_SSs]

Phil

See if this is what you want. Formula in F8 (copied across and down):
=VLOOKUP($E8,$A$1:$D$4,COLUMNS($E8:F8),0)

Mr Excel.xls
	A	B	C	D	E	F	G	H	I
1		Type	Price	Quantity
2	Hammer	A	2	300
3	Nails	B	3	500
4	Screwdriver	C	2.50	400
5
6
7
8					Hammer	A	2	300
9					Nails	B	3	500
10					Hammer	A	2	300
11
Vlookup

 

[Philip Wong]

Thanks Peter.