Hi all.
I know i can use this formula =IF(ISNA(VLOOKUP("*"&"Hat"&"*",$A$1:$B$10,2,0)),"",VLOOKUP("*"&"Hat"&"*",$A$1:$B$10,2,0)) in the below list to find the number 3.
dog 1
cat 2
tophat 3
cow 4
pig 5
But how would i be able to find the number 3 doing this...