starsky
03-16-2011, 05:22 AM
Hi,
Is there a VBA alternative to using a frequently used look up table? E.g. In the look up table there would be 2 columns Directorate & DirCode, where Directorate is a full name and DirCode a code (in reality there would be further columns for other organisational levels).
Instead of me having to navigate to and open the file with the look up table, and then write out the vlookup formula, can I store this table in VBA and use it from there?
Many thanks.
Is there a VBA alternative to using a frequently used look up table? E.g. In the look up table there would be 2 columns Directorate & DirCode, where Directorate is a full name and DirCode a code (in reality there would be further columns for other organisational levels).
Instead of me having to navigate to and open the file with the look up table, and then write out the vlookup formula, can I store this table in VBA and use it from there?
Many thanks.