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:
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

eliW

Well-known Member
Joined
Mar 2, 2002
Messages
1,936
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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,994
Messages
5,834,773
Members
430,320
Latest member
Napzz

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top