Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Novice when it comes to using If statements and Vlookup.
I have a list of people and one cell containing the full address (street, town, postcode). I want to be able to sort all the records into districts. I can produce a list of which towns are in which districts which would e good in a vlookup table but how do I extract the town from the cell. Is there a method to tell the lookup table to match part of the cell. Or do I have to extract the town from cell into a separate column that can then be used for the Vlookup? If so, how? Towns and postcodes are irregular in length. So can't count characters from right as I have seen in others samples on this site. Any help would be most gratefully appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
click on part# in pulldown list fills description cell in next col | Excel Worksheet Functions | |||
sort subtotal groups | Excel Worksheet Functions | |||
sort by groups in excel | Excel Discussion (Misc queries) | |||
Sort Groups of Cells | Excel Worksheet Functions | |||
How can I sort in groups of 3 rows? | Excel Worksheet Functions |