index and match Mid in a array

[nihad]

Hi everyone

is it possible to look for a value based on search value to be Mid and array to be Mid as well?

=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

 

[Fluff]

You need to specify an exact match

=INDEX($AG$6:$AG$160,MATCH(MID(AF273,6,6),(MID($AF$6:$AF$160,6,6)),0))

 

[Fluff]

You beat me to it.
Glad you sorted it & thanks for the feedback.

 

[nihad]

You beat me to it.
Glad you sorted it & thanks for the feedback.

Thank you so much for your help

 

[Fluff]

My pleasure.