Paul
Thank you and you are right-on here. I have not specified the main goal of the search.
I have clean it up and added criteria. You will see the search page and what Im after. I think a "index, match" function is best? But the area of search labeled 2a,2b,2c will required a different kind of search, I think, and may require more thought (have sub-in drop down as example) but this is the direction I am trying to achieve.
Please see rev.3 , at first thread.
I see another problem of have more then one answer here, no clear to handle that either, drop down? or just multiple list?
Last edited by windseaker; 03-03-2013 at 12:16 PM.
Reason: updated spreadsheet
|