VBA to output a value based on value from a Lookup table

[Cailin]

Hi there,

I am new to VBA so this may be relatively straightforward. I am pulling data from several different workbooks, one of the values I want to extract I want to change it when outputted based on what I have in a Lookup table. To explain further I want to take the value in A1 and compare it to the value in my Lookup table and then give the value in the adjacent column.

For example:
A1 values from different workbooks

WB1.S1.A1      WB2.S1.A1       WB3.S1.A1
SalesUK        SalesUS         SalesEur

Lookup Table

A         B
SalesUK   UK
SalesUS   US
SalesEur  EUR

so if A1 in workbook 1 is equal to "SalesUK", I want to then check the lookup table for this value and output the value in column B, "UK".

If anyone can help that would be great.

Thanks in advance