| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup a Canada postal code in a range of values
I have two spreadsheets: One with a list of various Canada postal codes
(e.g., V2N4Z9) and one with various ranges of Canada postal codes (e.g., Start Postal Code = V2R4Y4, End Postal Code = V2R5B7). However the postal code ranges aren't consecutive. What Excel function/formula can I use to determine if the postal code in the first spreadsheet is within one of the postal code ranges in the second spreadsheet? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cdn Postal Code | Excel Discussion (Misc queries) | |||
| Canadian Postal Code format? | Excel Worksheet Functions | |||
| How do I retain a zero as the first number in a postal code? | Excel Discussion (Misc queries) | |||
| Validation of Postal Code | Excel Worksheet Functions | |||
Threaded Mode
