Hi all,
I have a sheet where the header row are Ground Shipping Locations and the numbers beneath it are the first 3 numbers of zip codes that pertain to that ground shipping location.
I need a formula that will return the Ground Shipping location upon entering the zipcode. The issue I am having is that the ground shipping locations appear multiple times in different columns. See an example below. Please HELP! and thanks in advance! The formula I put together which is not working is =INDEX(Sheet2!A1:DX78,1,SMALL(IF(Sheet2!A1:DX78=I3,COLUMN(Sheet2!A1:DX1),99*99),1)) where 'sheet 2' is where the data below is located and cell I3 is where I am entering the zipcode on a separate sheet.
The top row is the header row with the ground shipping locations. The numbers underneath are the zip codes associated with that ground shipping locations.
<colgroup><col width="64" span="13" style="width:48pt"> </colgroup><tbody>
</tbody>
I have a sheet where the header row are Ground Shipping Locations and the numbers beneath it are the first 3 numbers of zip codes that pertain to that ground shipping location.
I need a formula that will return the Ground Shipping location upon entering the zipcode. The issue I am having is that the ground shipping locations appear multiple times in different columns. See an example below. Please HELP! and thanks in advance! The formula I put together which is not working is =INDEX(Sheet2!A1:DX78,1,SMALL(IF(Sheet2!A1:DX78=I3,COLUMN(Sheet2!A1:DX1),99*99),1)) where 'sheet 2' is where the data below is located and cell I3 is where I am entering the zipcode on a separate sheet.
The top row is the header row with the ground shipping locations. The numbers underneath are the zip codes associated with that ground shipping locations.
Ground | 002 | 045 | 045 | 002 | 003 | 002 | 003 | 004 | 003 | 004 | 003 | 002 |
004 | 006 | 009 | 010 | 014 | 015 | 017 | 043 | 045 | 046 | 050 | 052 | |
005 | 007 | 009 | 011 | 014 | 016 | 018 | 044 | 045 | 047 | 051 | 053 | |
012 | 019 | 048 | ||||||||||
013 | 020 | 049 | ||||||||||
021 | ||||||||||||
022 | ||||||||||||
023 | ||||||||||||
024 | ||||||||||||
025 | ||||||||||||
026 | ||||||||||||
027 | ||||||||||||
028 | ||||||||||||
029 | ||||||||||||
030 | ||||||||||||
031 | ||||||||||||
032 | ||||||||||||
033 | ||||||||||||
034 | ||||||||||||
035 | ||||||||||||
036 | ||||||||||||
037 | ||||||||||||
038 | ||||||||||||
039 | ||||||||||||
040 | ||||||||||||
041 | ||||||||||||
042 |
<colgroup><col width="64" span="13" style="width:48pt"> </colgroup><tbody>
</tbody>