Q:

AND/IF/MIN - Function excel

I'm trying to find the min value of something from table based on three criterias.
I have tried the following without any succes:
=MIN(IF(AND(Table[Letter]="F";Table[Level]=A2;Table[Title]]=B2");Table[Amount];"-"))

There should be a value based on these three criterias but I'm getting nothing.
Table is a table found in another worksheet

A:

I understand that you want the "-" to show up in case no row matches the criteria, otherwise show the minimum matching amount. The best way to achieve this is by using the AGGREGATE function (Excel 2010+):
=IFERROR(AGGREGATE(15, 6, Table[Amount] / (Table[Letter]="F") /
   (Table[Level]=A2) / (Table[Title]=B2), 1), "-")

p.s.: change the commas , to semi-colons ; to adapt it to your locale.

