PDA

View Full Version : Solved: VBA alternative to a look up table



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.

Bob Phillips
03-16-2011, 08:22 AM
You could read it in on workbook open, store in on a hidden sheet with a defined name, and use that name in the formulae.

starsky
03-16-2011, 08:41 AM
Could that be stored in a PERSONAL file?

mdmackillop
03-16-2011, 01:30 PM
You could, but personally I would not. You could however save it in another Hidden workbook saved in your XLStart folder. That would give similar access to the data.

starsky
03-17-2011, 05:17 AM
Ok, thanks guys. I'll look into these options.