Re: Excel makro

From: mail@pp21.cz
Date: 20. 05. 2002, 13:09 CEST

Previous message: Jiri Cvrk: "rychly provider pres isdn"
In reply to: Simona Trneckova: "Excel makro"
Next in thread: Simona Trneckova: "Re: Excel makro"
Reply: Simona Trneckova: "Re: Excel makro"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

>
=IF(K7="k";K1;"((=VLOOKUP(J5;'H:\Vzory\[TZM.xls]Stavby'!$A:$L;12;FALSE)")
> Prosim poradte, mam tu chybu ve formuli....
> S.

Tak je to makro, nebo vzorec? Nemelo by to byt spis takhle:

=KDYŽ(K8="k";K2;VVYHLEDAT(J5;'H:\Vzory\[TZM.xls]Stavby'!$A:$L;12;NEPRAVDA)
)

respektive

=IF(K8="k";K2;VLOOKUP(J5;'H:\Vzory\[TZM.xls]Stavby'!$A:$L;FALSE))


-pp21-

Previous message: Jiri Cvrk: "rychly provider pres isdn"
In reply to: Simona Trneckova: "Excel makro"
Next in thread: Simona Trneckova: "Re: Excel makro"
Reply: Simona Trneckova: "Re: Excel makro"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

This archive was generated by hypermail 2.1.2 : 20. 05. 2002, 13:10 CEST