Vlookup ability

[Martin3105]

Is it possible for me to use vlookup to auto-populate another sheet? For example, I have the tables below

Worksheet 1

Sheet 1 (list)

Boston	Boston Manor	Boston Village	Boston Villa	Crawford
Raleigh	Raleigh Manor	Raleigh Village	Raleigh Villa	Dansforth
Manning	Manning Manor	Manning Village	Manning Villa	Countryside

<tbody>
</tbody>

Worksheet 2

Not sure if this is the correct code: =VLOOKUP(Sheet1!A:A,Sheet1!1:100,Sheet1!B:J,FALSE)

I selected Boston (when selecting Boston the table should look like this)

Boston Manor

Boston Village

Boston Villa

Boston Crawford

<tbody>
</tbody>

Any help will greatly be appreciated.

 

[Fluff]

Vlookup is value to find, range to find it in, column to return value from, https://exceljet.net/excel-functions/excel-vlookup-function