Can anyone help with a formula that would search a column for a zip code, move one column right and search for the first occurrence of a specific word on the next level of that outline, and then add the number that's in the cell 4 over to the right.
Thanks