Hi,
I was wondering if someone could point me in the right direction please…
I have a list (see below) and need to search for entries. There are names and numbers. User will enter a number and I need to show the next name searching upwards.
The list is very long and we have all in column A.
For example… a search for 11111111 should return Fred.
Bob
32123123
21321312
56456566
Fred
54656566
11111111
34345455
32434344
33434344
Marry
56677689
Thanks a lot!
Bookmarks