I'm trying to create a function/formula that will return certain Text depending on a range of values. In the attached file is my sample. When someone types a zip code into B1 I would like cell C1 to respond "20 Mile Radius" if it falls within range A2:A59 on the "Zips" sheet, "25 Mile Radius" for B2:B93, "30 Mile Radius" for C2:C132, "40 Mile Radius" for D2:D236, and "50 Mile Radius" for E2:E394. I don't know if the list of zips have to be in a list like that or if there's a way to add them directly into a formula with commas or such.
Thanks!
Bookmarks