ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Vlookup with wildcard (https://www.excelbanter.com/excel-discussion-misc-queries/65095-vlookup-wildcard.html)

Peter

Vlookup with wildcard
 
I want to set up a list with certain zip codes but do not want to put them
all in. Is there a way I can use wildcards?
When the zip code is found, it will put "local" in the cell.
example:
zip code code
10300 Local
10301 Local
10302 Local
.......
.......




All times are GMT +1. The time now is 04:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com