HLookup with and function

Thanks for a very simple solution, though I was not expecting to have a1, a2......

Thanks again.

try this

with small changes

Punnam

Originally Posted by Punnam

try this

with small changes

Punnam

As I wanted to keep sanitized version I have renamed to 'a', 'b', 'c', '1', '2', '3', '4'......... but these are names of different categories and series, hence don't think the 'Sumif' function will be an idle solution. can you help me without bothering about the headings....

Originally Posted by rajasekhargvd

As I wanted to keep sanitized version I have renamed to 'a', 'b', 'c', '1', '2', '3', '4'......... but these are names of different categories and series, hence don't think the 'Sumif' function will be an idle solution. can you help me without bothering about the headings....

In that case you should clarify the below
1) Was "A" name is common for all the three sub division 1 2 3 4
2) 1,2,3,4 are they same for a,b,c
3) IF not same weather it is possible for us match them
4) What is the logic between A & 1,2,3&4
Punnam

Originally Posted by Punnam

In that case you should clarify the below
1) Was "A" name is common for all the three sub division 1 2 3 4
2) 1,2,3,4 are they same for a,b,c
3) IF not same weather it is possible for us match them
4) What is the logic between A & 1,2,3&4
Punnam

Please find here below the clarifications:
1 - Yes, 'a' is having 4 sub-divisions called 1,2,3,4
2 - Yes, 1,2,3,4 are same for a,b,c.....
3 - Those are same
4 - No specific logic only 1, 2, 3, 4 are unique sub divisions of a, b, c...

Hope this clarifies your queries.