Town/City to lookup county
Closed
mohalloran
Posts
2
Registration date
Tuesday March 15, 2016
Status
Member
Last seen
March 15, 2016
-
Mar 15, 2016 at 12:53 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Mar 17, 2016 at 12:00 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Mar 17, 2016 at 12:00 PM
Related:
- Https //accounts.google.com/sign in/v1/lookup
- How to recover Google account password: without phone number - Guide
- Snapchat sign up - Guide
- English keyboard @ sign - Guide
- Yahoo sign up - Guide
- Sign in helper - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Mar 15, 2016 at 01:03 PM
Mar 15, 2016 at 01:03 PM
Hi Mohalloran,
Try the VLOOKUP formula:
=VLOOKUP(The address you want to lookup, the matrix addresses and countries are located, 2, 0)
Best regards,
Trowa
Try the VLOOKUP formula:
=VLOOKUP(The address you want to lookup, the matrix addresses and countries are located, 2, 0)
Best regards,
Trowa
Mar 15, 2016 at 01:35 PM
Mar 17, 2016 at 12:00 PM
Let's say the address you want to look up is in sheet 'Town &City' C2.
The matrix with addresses and countries are located in sheet 'Master' B:C.
Then the formula in sheet 'Town &City' D2 will look like:
=VLOOKUP(C2,'Master'!B:C,2,0)
The value in C2 will be looked up in column B of Master sheet. The corresponding value in column C of Master sheet will be returned, hence the 2 (second column in the matrix) after the 2nd comma. The final zero means that the addresses in column B of Master sheet don't have to be in alphabetical order.
Best regards,
Trowa