Excel

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.
 
H

hcj

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.
 
Top