CODEWITHSUNDEEP
excelworksheet-function
Brett
Brett

Reputation: 1

Search and Extract Excel Spreadsheet

I have a table of information. In the first column I have names 1-10. I also have 10 columns named jobs 1-10. I have the data all in between based on the name of the person. For example, if you look at name 3 they have 10 jobs in the same row. My question is, I have created a drop down list with the 10 names below that table. What I want to do is when I click the name from the dropdown list, the row for that name automatically gets populated across the row in the 10 columns. I have tried VLOOKUP but having trouble with the different syntax options. Anybody have an idea?

Upvotes: 0

Views: 432

Answers (2)

Alex P
Alex P

Reputation: 12489

If I understand your issue correctly, the following may help.

Let's suppose your data is set-up like this:

      A        B       C       D
1     Name     Job1    Job2    Job3
2     Bob      Washing Vacuum  Ironing
3     Sue      Dust    Polish  Mop

Now in cell A5 I have a drop down list of names i.e. Bob and Sue. When I select a name in A5 I want all their jobs in the same row i.e. cells B5, C5 and D5.

B5 =VLOOKUP($A$5, $A$1:$D$3, 2, false)
C5 =VLOOKUP($A$5, $A$1:$D$3, 3, false)
D5 =VLOOKUP($A$5, $A$1:$D$3, 4, false)

Does that help? I appreciate you have 10 jobs but you can easily replicate.

Upvotes: 1

Stefan Steiger
Stefan Steiger

Reputation: 82176

You need to return values into several fields.

VLOOKUP returns a scalar. You need to write a macro. You can record and then change the things you recorded.

Upvotes: 0

Related Questions