Find Text Within Text Range, Return specific value

[bellous]

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.

 

[NeonRedSharpie]

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.

 

[bellous]

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:

	Zip	Address	Customer ID
	123456	123 fake street, AZ 123456 US	895623
	456123	456 nope lane, FL 456123	784512

<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