LOOKUP AND REPLACE QUERY

[PM1]

I have 2 Spreadsheets. I want to copy the value from 1 cell into another sheet but I have multiple lines with the data in 1 sheet but only 1 line of the same data in another in another. Sheets below:

Purch Orders BP²I.xls
	A	B	C	D	E	F	G	H	I
1	PSPONo	LineNo	Company	PartNo	Details	Qty	UnitCost(GBP)	Expense/Asset	AssetValue
2	4		Repton	292889-421	ProLiantDL360(G3)R02XeonDP2.8GHz,512MB				2,217
3	4		Repton	292892-B21	XeonDP2800/512-533ProcessorOptionKit
4	4		Repton	300678-B21	512MB(266MHz)DDRPC2100RegisteredECCSDRAM
5	4		Repton	286714-B22	72.8GB(10000rpm)PluggableHardDiskDrive
6	4		Repton	293703-B21	DL380G3HotPlugRedundantPowerSupply
7	4		Repton	263825-B21	IntegratedLights-OutAdvancePack
8	4		Repton	331903-B21	SlimlineDVD-ROM/CD-RWComboOptionKit
9	4		Repton	BUILD	inhousebuildandtest
10	4		Repton	DEL-NEXT	delivery
11	8		Repton	325134-421	ProLiantDL580(G2)R02Xeon				13,555
Assets

Master Asset File.xls
	K	L	M	N	O
1	Text	AcquisitionCost	AccDpen	NBV	PONo
2	292889-421ProLiantDL360(G3)R02XeonDP2.8GHz,512MB	2,055.00		2,055.00	4
3	292889-421ProLiantDL360(G3)R02XeonDP2.8GHz,512MB	2,055.00		2,055.00	4
4	292889-421ProLiantDL360(G3)R02XeonDP2.8GHz,512MB	2,055.00		2,055.00	4
5	292889-421ProLiantDL360(G3)R02XeonDP2.8GHz,512MB	2,055.00		2,055.00	4
6	292889-421ProLiantDL360(G3)R02XeonDP2.8GHz,512MB	2,055.00		2,055.00	4
7	292889-421ProLiantDL360(G3)R02XeonDP2.8GHz,512MB	2,055.00		2,055.00	4
8	325134-421ProLiantDL580(G2)R02Xeon	10,055.00		10,055.00	8
BP²I Assets

So I want to replace L2:L7 in the Master Asset File with I2 from Purch Orders. The PO NO (4) is a common denominator but I could have more than 1 desc with the same PO. So I need to look at the PO No and match the Text Col in Master Asset File with Part No & Details from the onther sheet.

Any ideas..??????

 

[eliW]

Hi,

Good advise!
Make your question simple. Give only nessesery details, or make a simple model similar to your heavy data. This will make it possible to answer your questin.

Eli

 

[PM1]

Thanks for the advice I think .......?

If I could put it simpler I would have