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.