LOOKUP AND REPLACE QUERY

PM1

Board Regular
Joined
Oct 28, 2005
Messages
192
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
ABCDEFGHI
1PSPONoLineNoCompanyPartNoDetailsQtyUnitCost(GBP)Expense/AssetAssetValue
24Repton292889-421ProLiantDL360(G3)R02XeonDP2.8GHz,512MB2,217
34Repton292892-B21XeonDP2800/512-533ProcessorOptionKit 
44Repton300678-B21512MB(266MHz)DDRPC2100RegisteredECCSDRAM 
54Repton286714-B2272.8GB(10000rpm)PluggableHardDiskDrive 
64Repton293703-B21DL380G3HotPlugRedundantPowerSupply 
74Repton263825-B21IntegratedLights-OutAdvancePack 
84Repton331903-B21SlimlineDVD-ROM/CD-RWComboOptionKit 
94ReptonBUILDinhousebuildandtest 
104ReptonDEL-NEXTdelivery 
118Repton325134-421ProLiantDL580(G2)R02Xeon13,555
Assets
Master Asset File.xls
KLMNO
1TextAcquisitionCostAccDpenNBVPONo
2292889-421ProLiantDL360(G3)R02XeonDP2.8GHz,512MB2,055.002,055.004
3292889-421ProLiantDL360(G3)R02XeonDP2.8GHz,512MB2,055.002,055.004
4292889-421ProLiantDL360(G3)R02XeonDP2.8GHz,512MB2,055.002,055.004
5292889-421ProLiantDL360(G3)R02XeonDP2.8GHz,512MB2,055.002,055.004
6292889-421ProLiantDL360(G3)R02XeonDP2.8GHz,512MB2,055.002,055.004
7292889-421ProLiantDL360(G3)R02XeonDP2.8GHz,512MB2,055.002,055.004
8325134-421ProLiantDL580(G2)R02Xeon10,055.0010,055.008
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..?????? :unsure:
 

Some videos you may like

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

eliW

Well-known Member
Joined
Mar 2, 2002
Messages
1,931
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

Board Regular
Joined
Oct 28, 2005
Messages
192
Thanks for the advice I think .......?

If I could put it simpler I would have
 

Watch MrExcel Video

Forum statistics

Threads
1,118,055
Messages
5,569,948
Members
412,299
Latest member
agentless
Top