Index Match from Column to Row

Vinton Douglas

Incoming sheet.png

Measurable Elements-source sheet.png

SmartLew

Hi Vinton,

Your Index match is formulated incorrectly, but either way I'm not sure that will get your job done.

In the column you have the index match in in your screenshot, which value are you trying to return? Just so I can understand your intended relationship between the two sheets.

Vinton Douglas

Thanks for responding. I am trying to return the results from the measurable elements sheet, i.2 Fully Met, Partially Met, Not Met and N/A. The results from that identified column of the measurable element sheet should be in the same order from left to right in the row of the incoming sheet.

Paul H

@Vinton Douglas

IF I am understanding what you are trying to do your formula you look like the

=INDEX({Status}, MATCH("ME 1", {Measurable Elements}, 0))

You would have to change the "ME 1" to ME 2" in to match each column name