Uploaded May 2018 | Updated September 2026, 12 minutes ago

---

1st code for selected city when description not blank. Leave a comment to vote for your favorite solution.
myspreadsheetlab.com/retrieve-1st-code-for-selected-city-when-description-is-not-blank
0:00 Intro
1:10 (a) vlookup array
3:01 (b) index & match array
4:29 (c) lookup
5:18 (d) helper & vlookup
6:03 (e) helper & vlookup (2)
6:50 (f) helper & index match
7:24 (g) index & array