vlookup with a twist.. ?

[St0ffe]

Ok, here goes...
I have a pricelist with a bunch of sheets and need to update the value if the workbook contains another value fot that material.

Example:

Sheet10

Material Price

123456 8€

I would like to update the price if sheet one contains this material.

To summorize; i would like to update the price in the pricelist but only if the material/ price is in "sheet1" otherwise leave as is.

Cheers, St0ffe

[NBVC]

i would like to update the price in the pricelist but only if the material/ price is in "sheet1" otherwise leave as is.

You can't do this as you request unless you apply VBA....

One way to do it without VBA is to add another column with a formula only.

e.g. =if(Isnumber(Match(A1,Sheet1!A:A,0)),Vlookup(A1,Sheet1!A:B,0),B1)

Where A1 is your Material and B1 is the current price...

The formula would be put in C1 and copied down.

Sheet1!A:B contain the listing of materials and prices.

The original column containing the original price can be hidden if desired

[St0ffe]

Thanks, works perfectly!

I can sleep again...

[St0ffe]

Just curious, how would the VBA code look?

Thank again, -St0ffe-

[NBVC]

I am not a VBA coder....

[St0ffe]

ok, thanks anyway