Hi everyone
is it possible to look for a value based on search value to be Mid and array to be Mid as well?
I have tried this but I get #N/A
My search value is column AF162 Mid 6,6 and my array table is AG6:AG160 but Mid 6,6, column index is AG
Many thanks
is it possible to look for a value based on search value to be Mid and array to be Mid as well?
Excel Formula:
=INDEX(MID(AG6:AG160,6,6),MATCH(AF162,MID(AF6:AF160,6,6),0))
I have tried this but I get #N/A
My search value is column AF162 Mid 6,6 and my array table is AG6:AG160 but Mid 6,6, column index is AG
Many thanks