I have a spreadsheet of over 200,000 records.
In column G I have the street address, column i the city and col K the state (in two letter abbreviation: IL, MT, CA, etc).
What I need is a function that will populate column L (currently blank) with the correct zip code based on columns G, i and K.
Can anybody come with a function for me to do this? I need it right away.