Vlookup Problem - excluding specific items when dragging down

[3smees23]

Hi,

Im using the following formula to update our prices in our stock list.

=VLOOKUP(C1,'Most Recent Prices 2009'!A:G,6,0)

Column C = Unique part number.

Problem:
I have a tab of 100 or so prices that I don't want to be updated. How can I exclude these pieces of equipment when I drag down the above formula. Assume that these pieces of equipment are in a tab called 'keep' and their unique part numbers are in Column A.

Thanks in advance

Sam

[NBVC]

Can you try again.. I am confused as to your question

Are you just looking for the last price listed for the item?

[3smees23]

Every few months we get a new price list from our suppliers, because of this I use the formula mentioned on the last post to update them.

But there are 100 service items that we have tripled in price that we need to stay the same. I have listed these items in the 'keep' tab. so i now need to update the v-lookup formula to emit any part codes stated in this 'keep tab'.

Hope this makes sense

Cheers

[NBVC]

Probably you need an IF() formula like below...

Please Login or Register  to view this content.

So if the Match is not found in column A of Keeps Sheet, it will look in Most Recent Prices 2009, otherwise it will look in the other sheet with Old Prices...

If not... then a sample workbook would help.

[3smees23]

Cheers NBVC.

I dont need this formula yet so i will check it in the near distant future. thanks