Excel - Lookup Query...
Closed
J.dot.E
Posts
1
Registration date
Thursday April 5, 2018
Status
Member
Last seen
April 5, 2018
-
Apr 5, 2018 at 09:24 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 5, 2018 at 11:51 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 5, 2018 at 11:51 AM
Related:
- Excel - Lookup Query...
- Excel marksheet - Guide
- Number to words in excel - Guide
- Excel free download - Download - Spreadsheets
- Kernel for excel - Download - Backup and recovery
- Excel date format dd.mm.yyyy - Guide
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Apr 5, 2018 at 11:44 AM
Apr 5, 2018 at 11:44 AM
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 September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Apr 5, 2018 at 11:51 AM
Apr 5, 2018 at 11:51 AM
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