vloop or code - entire row

[nt82]

Hello All,

So I have office locations in sheet 1 as follows:

Location	Address	City	State	Zipcode
Chicago	243 W Jackson	Chicago	IL	60605
New York	505 W 50th St	New York	NY	10019
Los Angeles	20 Calabasas Road	Los Angeles	CA	98490

<tbody>
</tbody>

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

Location	Address	City	State	Zipcode
Chicago

<tbody>
</tbody>

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.