Excel

  • Thread starter Thread starter Glen
  • Start date Start date
G

Glen

Help !! - I want to update my excel pricelist from an
updated supplier's excel price list.

Column A has Suppliers Code in both Worksheets
Column B has Suppliers price in both worksheets

If text in cell of Column A (my worksheet) = Text in cell
of Column A (suppliers worksheet)
Then
Replace Value of appropiate cell in Column B (my
worksheet) with the Value of appropiate cell in Column B
(Suppliers Worksheet)

My W/sheet Suppliers W/Sheet
Code Cost Code Cost
AAAA $5.00 AAAA $5.00
BBBB $4.00 BBBB $4.50

Want to replace the valuse for BBBB of $4.00 with updated
value of $4.50 How can I achieve this???

Help me please.
 
Hi Glen,
If the codes are unique for each entry in the supplier's
sheet (I'm guessing they are), you can use the supplier's
sheet, sorted by code, as a lookup table. You can then
use a lookup formula in the price field on your sheet to
hold the value found in the supplier's sheet.

Hope this helps you.
 
Back
Top