Searching for text or numbers in textbox
I am trying to set up a spreadsheet where I can search
for a number or a name in a two column sheet
12345 ABCDEFGH
23456 XYZABCDE
46789 EFGHIJKL
45612 ZAYBCXDV
I need to be able to search for a number and the search
gives the corresponding name and number.
Or search the name and it gives the number and name.
I would like to put the value in a textbox and the output
to be placed in a list box.
Any thoughts,
Ian,
|