I have some raw data in an Access DB of Zip Codes, and then reference numbers associated with those codes.
Right now, I have the zip code data in excel, but I am trying to pull it out of excel so that we can get the file size down, and the file can run smoother.
The formula we are using (to reference the info currently in excel) is as follows
LOOKUP(2,1/(($A17>=Origin_LB*1)*($A17<=Origin_UB*1)*($B17>=Destination_Zip_LB*1)*($B17<=Destination_Zip_UB*1)),ZoneGND)
to compare origin and destination zip codes to return a number listed in Column E.
I need this calculation to occur where excel goes to access finds the correct number and returns it to a cell in Excel, instantly when the zip codes are entered into A17 and B17. However I do not want to load the entire table into excel because of the amount of data it consumes.
Is this possible???
Bookmarks