Another HARD VLOOKUP Problem, can it be done ?

  • Thread starter Thread starter Roby
  • Start date Start date
R

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,

VLOOKUP finds only one value from one row. You need to use a filter perhaps
(Data menu). Describe your situation more.
 
i would take excel and throw it out the window. Access is much better
at this type of activity.
 
Back
Top