CODEWITHSUNDEEP
excelvlookup
Dylan Mecagami
Dylan Mecagami

Reputation: 39

data validation that will return multiple values through vlookup

I have a data validation that will return multiple values from a table. I used vlookup func to make this, however is there a shorter way to make this without having a different formula apply to each cells..

vlookup used in each cells

B2: =VLOOKUP($A$2, $G$1:$J$7, 2,FALSE)
C2: =VLOOKUP($A$2, $G$1:$J$7, 3,FALSE)
D2: =VLOOKUP($A$2, $G$1:$J$7, 4,FALSE)

myExcel

Upvotes: 0

Views: 1008

Answers (2)

Subodh Tiwari sktneer
Subodh Tiwari sktneer

Reputation: 9976

You may also try Index/Match instead of Vlookup in this case.

In B2

=INDEX(H:H,MATCH($A2,$G:$G,0))

and copy across.

Upvotes: 1

BruceWayne
BruceWayne

Reputation: 23285

There are a few ways you can do it. Keeping with VLOOKUP(), a quick change is to use column():

=VLOOKUP($A$2, $G$1:$J$7, column(),FALSE)

Since you appear to have 2 in column 2, in any cell in column B if you use =Column(), it'll return 2.

Upvotes: 0

Related Questions