Using Arrays to populate a column based on a look up type table

[welchs101]

Hi,

I have a very complex look up table. See lookup worksheet in the enclosed excel file.

I will be given a data file like the data shown on "Sample Data" sheet in the enclosed file. There will be many rows of data..........

I want to use a vba program (not formulas....unless the formula can be used in vba) to fillin the last column on the "Sample Data" worksheet.

My problem has been the look up table is kinda complex and getting the loops correct and efficient is turning into a mess.

Any ideas?