May 25 2021 01:19 AM
Hi guys,
Appreciate your expert advise on why my Index don't return all the values despite the row and column is derived successfully from the Match( ).
I inserted two examples in Sheet 1. It seems like the name is not recognized.
May 25 2021 01:35 AM
SolutionPlease exchange MATCH() positions within INDEX(), one which return row is on first position and with column on second one.
Please check attached.
May 26 2021 07:05 AM
@Sergei Baklan Thank you very much. You triggered something i missed!
May 25 2021 01:35 AM
SolutionPlease exchange MATCH() positions within INDEX(), one which return row is on first position and with column on second one.
Please check attached.