Sheet 1 contains bldg name(column A), bldg street address(column B),
City(column C) etc.
Sheet 2 is a job/project log. I would like the user to type in only the bldg
name in column A and have the other columns auto populate in the respective
columns in sheet 2.
How can this be accomplished?

Thx!

Try something like this on Sheet2:

B2: (a bldg name)

The street
C2: =VLOOKUP($B2,Sheet1!$A:$E,2,0)

The city
D2: =VLOOKUP($B2,Sheet1!$A:$E,3,0)

etc

OR....
C2: =VLOOKUP($B2,Sheet1!$A:$E,COLUMNS($A2:B2),0)
copy C2 across to the right.....each successive cell will return more of the
address.

Is that something you can work with?
***********
Regards,
Ron

XL2003, WinXP


"James" wrote:

Sheet 1 contains bldg name(column A), bldg street address(column B),
City(column C) etc.
Sheet 2 is a job/project log. I would like the user to type in only the bldg
name in column A and have the other columns auto populate in the respective
columns in sheet 2.
How can this be accomplished?

Thx!