I am having trouble coming up with the correct function coeding for
this Excel database. I know I would need to use IF, VLOOKUP, INDEX and
ROW. But in what order and how I just cant seem to get it. When you
open the file you will see the sheet called Search and then there is
another sheet (Data) where I have all the info. I would like to type
in the blanks what I am looking for and it will search threw the data
and pull all the ones with the criteria's I need and show them under
Result.
Thank you in advance.
BR,
John
Here is the File.
http://www.mediafire.com/?1xbte8mt9w3