# Multiple search criteria within the same spreadsheet

#### Lore0818

##### New Member
Hello all,
I'm sure you can tell I'm a newbie to excel by the thread I'm posting. I've read so many posts on multiple searches, however I couldn't find any that fits what I'm looking for. Maybe I'm tired and just can't see or think outside the box.
It's simple what I'm trying to do and would be soooooo helpful.

I'm trying to look up multiple zip codes at the same time in one spreadsheet.
I have found online where I can group all the zip codes within a 25 mile radius of a specific location.
Now, I'm trying to lookup all those 20+ zip codes on a spreadsheet which contains client info including their zip code (in a separate column)
Column I containes the zip codes I'm trying to search in the spreadsheet of about 2000+ rows of data.

Thank you advance for any help.

#### Saba Sabaratnam

##### Active Member
Try this formula. Copy this formula as it is in F2 and copy it down.

if it does not work, copy a data point (say D2) as text so that I can see the structure of your data.

Kind regards

Saba

### Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

#### Lore0818

##### New Member
I'm sorry, I don't understand what you're asking me to do.
I promise I won't get offended if you give me instructions as if I was 4 years old.

#### Saba Sabaratnam

##### Active Member
no problem

You could try this approach.

Enter the following formula in F2 and copy it down to extract first five digits of your code and turn it to number.

=TRIM(CLEAN(LEFT(D1,5)))*1

Then this formula in G2 and copy it down.

Kind regards

Saba

#### Lore0818

##### New Member
These are my results.

#### Attachments

• 1625677696575.png
73.6 KB · Views: 1

#### Saba Sabaratnam

##### Active Member

Try this formula by coping in F1 as it is.

Then copy F1 and paste the formula from f2 to the last row of data of column F.

Kind regards

Saba

#### Lore0818

##### New Member
These were my results "not found" all the way down the F column. I even checked every so many rows all the way down to make sure it had been copied all the way through.

#### Saba Sabaratnam

##### Active Member

It is referencing to wrong lookup reference.

Use this formula .

Kind regards

Saba

#### Lore0818

##### New Member
if won't let me use 2 equal signs..... ==

#### Saba Sabaratnam

##### Active Member

Include 75041 in J3 (replace 76511 with this number) to see if the formula produces 75041 or

Also can you please confirm that you have office 365?

Kind regards

Saba

#### Lore0818

##### New Member
Yes...Yes...YES!!!!!
The last formula worked. I created a filter in column F (which I should've done from the beggining) and it displayed what I was looking for.
Thank you SOOOOOOOO much Saba.

Replies
1
Views
159
Replies
5
Views
529
Replies
6
Views
567
Replies
1
Views
161
Replies
1
Views
194

1,148,283
Messages
5,745,842
Members
423,981
Latest member
ph1l

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back