Excel - Lookup Query...
Closed
J.dot.E
Posts
1
Registration date
Thursday 5 April 2018
Status
Member
Last seen
5 April 2018
-
5 Apr 2018 à 09:24
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 5 Apr 2018 à 11:51
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 5 Apr 2018 à 11:51
Related:
- Https //accounts.google.com/sign in/v1/lookup
- How to recover Google account password: without phone number - Guide
- At sign - Guide
- Underscore sign in keyboard - Guide
- Orkut sign in - Guide
- Skype sign up - Guide
2 responses
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
5 Apr 2018 à 11:44
5 Apr 2018 à 11:44
J.dot.E, Good atfernoon.
I'm sorry but your explanation is very superficial
It's necessary that we can have more information about the layout of your spreadsheet so that we can effectively assist you.
Please, save your worksheet to some free website, www.sendspace.com or another and put the download link here.
Remember to show the data you have and put what would be the expected result.
Give some concrete examples so that we can understand your doubt.
--
Belo Horizonte, MG - Brasil.
Marcílio Lobão
I'm sorry but your explanation is very superficial
It's necessary that we can have more information about the layout of your spreadsheet so that we can effectively assist you.
Please, save your worksheet to some free website, www.sendspace.com or another and put the download link here.
Remember to show the data you have and put what would be the expected result.
Give some concrete examples so that we can understand your doubt.
--
Belo Horizonte, MG - Brasil.
Marcílio Lobão
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
5 Apr 2018 à 11:51
5 Apr 2018 à 11:51
Hi J.dot.E,
I would advise you to extract the postcode from column A on sheet 1. Not sure how the address is structured, but if the postcode is last, you could use the Right function:
=RIGHT(A2,8)
Or using the 'Text to columns' option found under the Data ribbon, depeding on your format.
Once you have done that, you can use VLOOKUP.
Make a habbit out of placing each type of data (street, number, city, postcode) in a separate cell to make data processing a lot more convenient. It also creates a better overview.
Best regards,
Trowa
I would advise you to extract the postcode from column A on sheet 1. Not sure how the address is structured, but if the postcode is last, you could use the Right function:
=RIGHT(A2,8)
Or using the 'Text to columns' option found under the Data ribbon, depeding on your format.
Once you have done that, you can use VLOOKUP.
Make a habbit out of placing each type of data (street, number, city, postcode) in a separate cell to make data processing a lot more convenient. It also creates a better overview.
Best regards,
Trowa
