|Use pre and /pre (enclosed in <>) to get text to stay where you want in this forum or click on the pre symbol above the Reply box and put your text in between. It'll take some playing around, but that's how I got the table in my post to line up. Done with pre:|
1 2 3 4 5 6 7
A B C D E F G
h i j k l m n
If you drag my VLOOKUP formula down a column, (e.g. Column F, since I used F1 in my example), it will change to F2, then F3, then F4, etc. and lookup each value in the column.
The $A$1:$B$4 (the lookup_array) will stay the same since the $ makes it an Absolute Reference, not like the F1 which is a Relative Reference.
Read up on VLOOKUP in Excel help to understand how each of the 4 arguments work.
If you don't want to build the lookup_array for VLOOKUP, I guess you could use a Nested IF statement as long as you have less than 8 cities to check.