00178 Retrieve Code Based on 2 Criteria
1st code for selected city when description not blank. Leave a comment to vote for your favorite solution.
https://www.myspreadsheetlab.com/retr...
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