Another HARD VLOOKUP Problem, can it be done ?

[Roby]

A hard problem with VLOOKUP !

Have serveral lines with Names/Adresses/Zip and a Cell with Codes
of my Family in Excel 2003.

I want to search it with VLOOKUP and one Cell of the found data
must than be viewed in a Horizontal way.

Example: VLOOKUP finds seven adresses with different codes
T 3
T 2
G 4
E 7
W 4

The question is how do i get this data Horizontal like this :

T 3 - T 2 - G 4 - E 7 - W 4 ( - = next Cell)

How do i do that ?

 

[Roby]

Is "=TRANSPOSE" an option and will it work with "VLOOKUP" ?

Anybody ?

 

[Earl Kiosterud]

Roby,

VLOOKUP finds only one value from one row. You need to use a filter perhaps
(Data menu). Describe your situation more.

 

[Roby]

Hello Earl,

Have send you an E-mail attached Example file with question.

Robert Udo

 

[aaron.kempf]

i would take excel and throw it out the window. Access is much better
at this type of activity.