Hi ,
I am trying to Match a partial of a string of a text "g" in range that has at least one cell which has a word that start/contain "g" : range : {q, ddfd, gsdfsd, rt}
as follows
=MATCH(
"*g*"
;
$AA$13:$AA$18
;0)
I was supposed to get : 3 but
I am getting this Error :
#EVAL!
Kindly help.