Excel 2007 : Help with Filters

[zeb_cz]

Hi, I´m not so good in excel, so I want to ask local masters to help me little bit.

I have added the file here. In this file, there is a bookmark Data and Vyhodnoceni. I want to add filters on some columns from bookmark Data (zakazka, polozka, dodavatel). With these filters, I want to select a specific row and automatically insert data into the table below. (cena, lhuta, podminky, zaloha).

Thanks for all advices.

Martin

[NBVC]

Not sure I fully understand but see attached to see if it is what you want.

Formula in B8 is (in English)... it will translate when you open the workbook.

=IFERROR(INDEX(Data!I$2:I$24,MATCH(1,INDEX((Data!$A$2:$A$24=$B$3)*(Data!$C$2:$C$24=$B$4)*(Data!$E$2:$E$24=$B$5),0),0)),"")

then in B9, you change only the first range Data!I$2:I$24 to Data!J$2:J$24 to get next column's data... and so on.