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!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return data from corresponding range
Michael: Thsi is really very easy with VLOOKUP if the table is alphabetical.
You only need to index column A and make sure RANGELOOKUP is TRUE col a col b 1 A0A A0O 2 A0P A0Z 3 A1A A1F 4 A1F A1G =VLOOKUP("A0R",A1:D1000,3) to get data in column C =VLOOKUP("A0R",A1:D1000,4) to get data in column D VLOOKUP in searching for A0R will stop at row 2 "Michael" wrote: 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!! |
Reply |
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) |