"Return" how, exactly? Also, do you have this information available in a more accessible format, like a spreadsheet? If so, then it can probably be done using a custom-made script.
Thank you for looking into it. I do have a spreadsheet, but was hoping to distribute a pdf file instead. Both XLS and PDF look exactly the same. The pdf is about 450 pages long with an index on Zip code.
Zip Group Group Description Mkt Area City State
00501 A Group A - Description Mkt-A HOLTSVILLE NY
01002 A Group A - Description Mkt-A AMHERST MA
01014 A Group A - Description Mkt-A CHICOPEE MA
01030 B Group B - Description Mkt-B FEEDING HILLS MA
01034 B Group B - Description Mkt-B GRANVILLE MA
01035 C Group C- Description Mkt-C HADLEY MA
01037 C Group C - Description Mkt-C HARDWICK MA
When I key 01030 in the Search box, the cursor jumps to the 4th row, highlighting only the zip code, making reading of the other columns a bit hard on the user.
Short of writing an Excel macro, I was hoping I could add a blank page as page 1 and then add the fields listed above...
Enter Zip Code: 01030 [Find] <-- User keys 01030 and presses [Find], at which point we display:
Group Description: Group A Description
Mkt Area Mkt-A
City Feeding Hills
This can be done (entirely in the PDF), but it requires a custom-made script.
The data from the spreadsheet will have to be converted to a plain-text file and attached to the PDF, and then the script could read it and populate the fields based on it.
If you're interested in hiring someone to develop this script for you, feel free to contact me privately at try6767 at gmail.com