Hi, I have a xl stamp database with some 34 columns and 4000+ lines. I need to be able to make a search (or should it be extract, sort, match, etc) possibly via a search box that has blank cells where I can fill in what I’m looking for, hit the go button and get either a unique solution, a non-solution or a list of possibles. The request word/s might not be the only word in any particular field/s of this db. Any direction as to the best formula to use would be great.
I use XL 03 and not up to speed with the advanced functions so any help would be wonderful. Many thanks in advance.
I use XL 03 and not up to speed with the advanced functions so any help would be wonderful. Many thanks in advance.
