How to check if value exist in VlookUp Table

[izet99]

Hi Guys,

Is there a way to check if value exists in Vlookup Table. I have two sheet in my workbook, one is Customer sheet and other is just Sales Type sheet with Vlookup Table. My Customer sheet has customer code column, that code is used to assign sales type from Vlookup Table.

Now, my report is dynamic and change from week to week, so this makes my Vlookup table give me a error output #N/A so I have to go in and update that table again, again, and again.

Is there a way to check if value exists in VLookUp table before I actually use that table.

If value (customer code) does not exist in VLookUp table than copy that customer code on last available cell in the VlookupUp table. This should be done untill all missing customer codes are not in VLookUp table. After all customer codes are available in VlookUp table then I would assign sales type by running VlookUp.

Is this possible with marco ili vb to run by pushing button to something like that.

Any help on this would be greatly appreciated.

[izet99]

Ohh Here is my workbook if needed.