New answers tagged


Try: =vlookup($E$2,$A$2:$B$6,2,false) Source data: cells A2:B6 Lookup field: cell E2. You can just enter a "name" in here, or (much easier) create a dropdown list from the range "A2:A6". Output cell: E3. The cell contains the formula shown above. The returned column is "2" = "City" Example

Top 50 recent answers are included