hi, would anyone know now to simply from a list of digits,
find (label "y") of the specific criteria of a input value say 3 in (C1)
example:
if C1 = 3
A1 B1
1
2
3 "y"
PS the lookup sample range always looks back from its current last position (not start position).
Bookmarks