Find Text Within Text Range, Return specific value

bellous

New Member
Joined
Sep 19, 2014
Messages
2
Frist time poster, having a difficult time putting together a formula for this problem I have. The issue is I have a column of zip codes, I then have a column of full addresses (ie street name, state, zip code, etc). My goal is for the cell to cross reference the zip codes with the addresses, if it finds a match, to then return the value of a third cell which will be their ID number.
 

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.
What columns are your cells in? Where do you want it to return? Can you post a sample data? It seems like a simple vlookup/index match.
 
Upvote 0
What columns are your cells in? Where do you want it to return? Can you post a sample data? It seems like a simple vlookup/index match.

Zip codes are in G2:G350
Addresses are in K2:K427 on a separate sheet
ID are in C2:C427 on a separate sheet

Example:

ZipAddressCustomer ID
123456123 fake street, AZ 123456 US895623
456123456 nope lane, FL 456123784512

<tbody>
</tbody>

I am trying to enter the forumla in a cell, have it use the zip code in adjacent cell, search for the zip code in the range of addresses, if found, return the adjacent customer ID
 
Upvote 0

Forum statistics

Threads
1,213,561
Messages
6,114,312
Members
448,564
Latest member
ED38

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top