Hi,
I'm new on this forum. I have a problem in getting rows from a multiple criteria. Below is my source table:
Sheet 1
Sheet 2:
I have 3 cells A, B and C.
A is for Resource and B is for Region. If I select DBA in cell A and Asia in cell B, then David and William will be added on my dropdown list for cell C. Someting like this:
Please help me in using OFFSET and MATCH functions for this.
Thank you in advance.
I'm new on this forum. I have a problem in getting rows from a multiple criteria. Below is my source table:
Sheet 1
Resource | Region | Name |
DBA | Europe | John |
DBA | Asia | David |
QA | Africa | Paul |
DBA | Asia | William |
QA | Asia | Henry |
QA | Europe | Mirla |
Sheet 2:
I have 3 cells A, B and C.
A is for Resource and B is for Region. If I select DBA in cell A and Asia in cell B, then David and William will be added on my dropdown list for cell C. Someting like this:
A | B | C |
Resource | Region | Name |
<dropdown> | <dropdown> | <dropdown> |
Please help me in using OFFSET and MATCH functions for this.
Thank you in advance.