View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
FinlandGuy FinlandGuy is offline
external usenet poster
 
Posts: 9
Default Database Search Function

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