variable to store multiple values

Hi Guys

I need a bit of help with the below macro which I am trying to create

I recorded the below vlookup, which works perfectly. It checks a list on sheet “Map” and returns a value depending on whether the reference is one of the 6 or not. These 6 are likely to change over time so I would prefer to declare them as variables rather than build them directly into the macro

Please Login or Register  to view this content.

Was thinking of declaring the variables which will always be in C2-C7 as below and substituting each reference in the vlookup. However something is wrong as I am getting a value of 1 for all

Please Login or Register  to view this content.

Can anyone suggest what might be wrong and how I might fix this please?

P.S. "Curr" is probably not the right one to use but am not sure which is

Thanks All

Noel

You could use MATCH:

Please Login or Register  to view this content.