Ok,
First time posting in this forum. I tried my best to solve this via google and YouTube but was unable to find a solution, so here I am. I have a complex formula that needs to use a Index function and be wrapped in with a match function as well. as you can see in the image. There is a list of names in column A (A11:A29) and a table with Yes/no results for programming language that those people understand (E11:K29). In S17 I need the name of the programmer that knows all of them. In this case Jang, Ling in row 15. Using a index formula how can I get his name to appear in S17?
You can download the XLS HERE to see the setup. Sorry have no other way of uploading the Sheet at this time. Thank you for you help it is greatly appreciated.
First time posting in this forum. I tried my best to solve this via google and YouTube but was unable to find a solution, so here I am. I have a complex formula that needs to use a Index function and be wrapped in with a match function as well. as you can see in the image. There is a list of names in column A (A11:A29) and a table with Yes/no results for programming language that those people understand (E11:K29). In S17 I need the name of the programmer that knows all of them. In this case Jang, Ling in row 15. Using a index formula how can I get his name to appear in S17?
You can download the XLS HERE to see the setup. Sorry have no other way of uploading the Sheet at this time. Thank you for you help it is greatly appreciated.