vloop or code - entire row

[nt82]

Hello All,

So I have office locations in sheet 1 as follows:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Location[/TD]
[TD]Address[/TD]
[TD]City[/TD]
[TD]State[/TD]
[TD]Zipcode[/TD]
[/TR]
[TR]
[TD]Chicago[/TD]
[TD]243 W Jackson[/TD]
[TD]Chicago[/TD]
[TD]IL[/TD]
[TD]60605[/TD]
[/TR]
[TR]
[TD]New York[/TD]
[TD]505 W 50th St[/TD]
[TD]New York[/TD]
[TD]NY[/TD]
[TD]10019[/TD]
[/TR]
[TR]
[TD]Los Angeles[/TD]
[TD]20 Calabasas Road[/TD]
[TD]Los Angeles[/TD]
[TD]CA[/TD]
[TD]98490[/TD]
[/TR]
</tbody>[/TABLE]

Now I m looking to auto populate data from sheet 1 to sheet2 whenever I just type Location.
So if I type - Chicago in Sheet2
[TABLE="width: 500"]
<tbody>[TR]
[TD]Location[/TD]
[TD]Address[/TD]
[TD]City[/TD]
[TD]State[/TD]
[TD]Zipcode[/TD]
[/TR]
[TR]
[TD]Chicago[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I would like Address, City, State and Zip code to be auto populate from Sheet1.

Thanks in advance for help.

 

[Joe4]

Use a VLOOKUP formula in each column.
See: https://exceljet.net/excel-functions/excel-vlookup-function

 

[nt82]

Thank You

 

[Joe4]

You are welcome.