Hi all
So I have an issue with index match.
Column A is my index (A3:10) and Column B (B3:B10) is my match to C1 and result is in C2
Column B contains blank cells.
When C1 is blank I need to see a result in C2 from Column A
At present I get N/A
My Function in C2 is =Index(A3:A10,Match(C1,B1:B10))
So I have an issue with index match.
Column A is my index (A3:10) and Column B (B3:B10) is my match to C1 and result is in C2
Column B contains blank cells.
When C1 is blank I need to see a result in C2 from Column A
At present I get N/A
My Function in C2 is =Index(A3:A10,Match(C1,B1:B10))