Hello,
I kindly request some help regarding a lookup according two criteria that I would like to set up with scripting dictionary.
what I have
1 workbook, 2 worksheets
First worksheet ("datasheet") contains in column A (the different questions= 1st criteria), in column B (pool participants names= 2nd criteria), in column C (the outcomes like yes, no, didn't answer). All three columns have a header.
the second worksheet ("compilation") contains in A2 downwards the unique name of participants and in B1 to the right are the questions
what I'd like is to populate the second worksheet("compilation") with the outcomes according to the two criteria. Some questions might have been asked to specific people but not to others.
Many thanks in advance.
winrow
I kindly request some help regarding a lookup according two criteria that I would like to set up with scripting dictionary.
what I have
1 workbook, 2 worksheets
First worksheet ("datasheet") contains in column A (the different questions= 1st criteria), in column B (pool participants names= 2nd criteria), in column C (the outcomes like yes, no, didn't answer). All three columns have a header.
the second worksheet ("compilation") contains in A2 downwards the unique name of participants and in B1 to the right are the questions
what I'd like is to populate the second worksheet("compilation") with the outcomes according to the two criteria. Some questions might have been asked to specific people but not to others.
Many thanks in advance.
winrow