leetmilf
New Member
- Joined
- Aug 31, 2014
- Messages
- 10
I process insurance claims - pricing is (partially) dependent on service location zip code. I have a table with all zip codes for all 50 states. Is my table array too large? I use Excel Professional Plus 2010 - and was under the impression that table array size was only limited by available memory. Here is a screenshot of my formula for vlookup:
Basically - the user will enter the zip code in I3; it will reference the table on 2014_ZIP_TO_LOCALITY worksheet; returning the 5 digit locality.
Ultimately - there are 2 types of claims. "Local" claims (for state of Michigan only) or "Interstate Claims" (for all other states). Should I try another avenue for this - I actually had it working until I changed the table array from MI only to all states. I would like this calculator to work for both claim types.
As you can see the array is B2:D42919 - which is huge. I'm an intermediate Excel user, but this is baffling me. Also - some zip codes have leading zeros - I3 has the zip code format, so the zeros are not truncated.
Basically - the user will enter the zip code in I3; it will reference the table on 2014_ZIP_TO_LOCALITY worksheet; returning the 5 digit locality.
Ultimately - there are 2 types of claims. "Local" claims (for state of Michigan only) or "Interstate Claims" (for all other states). Should I try another avenue for this - I actually had it working until I changed the table array from MI only to all states. I would like this calculator to work for both claim types.
As you can see the array is B2:D42919 - which is huge. I'm an intermediate Excel user, but this is baffling me. Also - some zip codes have leading zeros - I3 has the zip code format, so the zeros are not truncated.
