Hello!
I am trying to use a formula to first Search vertically within a column for "VALUE A", then search within the row of "VALUE A" for "VALUE B", then output "VALUE C" from row 1 of the column that "VALUE B" is located within. Here is a photo of what I would like:
I have found something similar to this, but it requires that the lookup value be the top row of the reference/array. In my situation, the output will always be above the second lookup value (value B). Here is an article that describes something similar, but it is NOT WHAT I WANT: How to Use INDEX MATCH MATCH
Does anyone know of a formula that I could assemble that would search above the second criteria as shown above?
ADDITIONALLY... I would like to create a second formula that will search for the last "value B" in a row and return the resulting time of that as well. Essentially, the first formula I need is described in the picture above, but I would like to create a second, separate formula that gives me the latest time. Value B represents an assigned task someone will be doing, and I want to output the start and end time of that task, for that person.
Thank you in advance for any help you can provide! I'll take suggestions even if they are not full answers/solutions!!!
I am trying to use a formula to first Search vertically within a column for "VALUE A", then search within the row of "VALUE A" for "VALUE B", then output "VALUE C" from row 1 of the column that "VALUE B" is located within. Here is a photo of what I would like:
I have found something similar to this, but it requires that the lookup value be the top row of the reference/array. In my situation, the output will always be above the second lookup value (value B). Here is an article that describes something similar, but it is NOT WHAT I WANT: How to Use INDEX MATCH MATCH
Does anyone know of a formula that I could assemble that would search above the second criteria as shown above?
ADDITIONALLY... I would like to create a second formula that will search for the last "value B" in a row and return the resulting time of that as well. Essentially, the first formula I need is described in the picture above, but I would like to create a second, separate formula that gives me the latest time. Value B represents an assigned task someone will be doing, and I want to output the start and end time of that task, for that person.
Thank you in advance for any help you can provide! I'll take suggestions even if they are not full answers/solutions!!!