vloop or code - entire row

nt82

Board Regular
Joined
Jan 29, 2009
Messages
128
Hello All,

So I have office locations in sheet 1 as follows:
LocationAddressCityStateZipcode
Chicago243 W JacksonChicagoIL60605
New York505 W 50th StNew YorkNY10019
Los Angeles20 Calabasas RoadLos AngelesCA98490

<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
LocationAddressCityStateZipcode
Chicago

<tbody>
</tbody>
I would like Address, City, State and Zip code to be auto populate from Sheet1.

Thanks in advance for help.
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,457
Office Version
365
Platform
Windows
You are welcome.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,567
Messages
5,469,453
Members
406,652
Latest member
LJA

This Week's Hot Topics

Top