Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return data from corresponding range
I have a table which represents ranges of postal codes. Column A holds the
bottom of the range, while column B holds the top of the range. For example in A1, I have A0A, and in B1 I have A0O. This represents the range of all postal codes from A0A to A0O. Column C and D hold data related to the postal code range - specifically, the shipping zone. I want to be able to input on another sheet any postal code (for example, A0G), and have the spreadsheet return the data in column C and D for the appropriate postal code range. I expect to have over 100 ranges. Hope I have explained this clearly. I appreciate any help you can offer!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
return range of data from lookup function | Excel Worksheet Functions | |||
If value in data range (multiple columns) return row | Excel Discussion (Misc queries) | |||
Vlookup to Return a Range of Data | Excel Discussion (Misc queries) | |||
Vlookup to Return a Range of Data | Excel Discussion (Misc queries) | |||
Lookup & Return Range of Data | Excel Discussion (Misc queries) |