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)

[TABLE="width: 500"]
<tbody>[TR]
[TD]Boston[/TD]
[TD]Boston Manor[/TD]
[TD]Boston Village[/TD]
[TD]Boston Villa[/TD]
[TD]Crawford[/TD]
[/TR]
[TR]
[TD]Raleigh[/TD]
[TD]Raleigh Manor[/TD]
[TD]Raleigh Village[/TD]
[TD]Raleigh Villa [/TD]
[TD]Dansforth[/TD]
[/TR]
[TR]
[TD]Manning[/TD]
[TD]Manning Manor[/TD]
[TD]Manning Village[/TD]
[TD]Manning Villa[/TD]
[TD]Countryside[/TD]
[/TR]
</tbody>[/TABLE]

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)

[TABLE="width: 500"]
<tbody>[TR]
[TD]Boston Manor[/TD]
[/TR]
[TR]
[TD]Boston Village[/TD]
[/TR]
[TR]
[TD]Boston Villa[/TD]
[/TR]
[TR]
[TD]Boston Crawford[/TD]
[/TR]
</tbody>[/TABLE]

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