CODEWITHSUNDEEP
excelvlookup
Nic
Nic

Reputation: 127

How to vlookup different values having same IDs within different groups

I am trying to figure out how to vlookup a value that has same name between different groups. I am trying to figure out how to vlookup a value that has same name between different groups. Given tables below:

enter image description here

What I would like to do is to fill Table 2 with the x values in Table 1, assuring that the subgroups actually belong to the right group.

Note that: Subgroups names are fixed, Group names change, number of subgroups within the groups may differ.

Upvotes: 0

Views: 1011

Answers (1)

Vinnie
Vinnie

Reputation: 553

Assuming, your groups are in column A and values in column B.

=INDEX(B:B,MATCH($E$2,INDIRECT("A" &MATCH($D$2,A:A,0)+1&":A1048576"),0)+MATCH($D$2,A:A,0))

enter image description here

Upvotes: 1

Related Questions