I have a worksheet that I am using vlookup to return values from a table (in the same workbook) based on a value I select in a drop down box in the worksheet...I want to change this up to use VBA and have the tables in a separate workbook.
So essentially...
I select a dropdown box value from a...