Auto populate from list/source

[Guest]

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!

 

[Guest]

Sorry, auto complete for bldg name in sheet 2. For instance if you entered in
B2 of sheet 2, the letter "a" it would filter the bldg names list to only
those beginning with "a" etc. until you choose from a handful of bldg names.

Thx again!

 

[Guest]

AutoFilter/Autocomplete on which cells/sheet?

***********
Regards,
Ron

XL2003, WinXP

 

[Guest]

Got it...Thanks!...now is there any way for bldg name to auto complete or
auto filter?

 

[Guest]

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

 

[Guest]

I'm baaack...now the problem is this. I'm cutting and pasting from a text
file into sheet 1. When I enter the information on sheet two it gives me a
"value not available" error. If I type(overwrite) the exact same information
in the same cell and go to sheet 2, the VLOOKUP formula works. I have 25000
records that I don't want to enter manually obviously. Any ideas?

Thx!
JR

 

[Guest]

It seems the pasted value and the typed value are not really the same at all.

Try this:
Type the correct value in a cell to the right of the pasted value.
Compare the two values using someting like =EXACT(A2,G2)......it should
return TRUE, but probably won't. Edit the pasted value and check for leading
or trailing spaces or any other anomalies. Let us know what you find.

***********
Regards,
Ron

XL2003, WinXP

 

[Guest]

Correct again! I used fixed width instead of delimited when importing and it
got rid of all trailing blanks/spaces. I'm on my way now!
Thx Again!
JR

 

[Guest]

Congratulations! I'm glad you figured it out.....and thanks for the feedback.


***********
Regards,
Ron

XL2003, WinXP