Hi,
My guess is that PROCV is a formula saved by that name.
Check out: Insert | Name | Define
Regards - Dave.
> Date: Wed, 28 Jul 2010 16:41:04 -0700
> Subject: $$Excel-Macros$$ Re: dont understand sintax...newbie!
> From: dlanm...@att.net
> To: excel-macros@googlegroups.com
>
Hi,
I have never heard of PROCV, so I am interested in this too.
David
On Jul 28, 4:18 am, x-plicit wrote:
> Hello All,
>
> I do not understand this sintax:
>
> =PROCV(sumproduct(max(($B$3:$B$13152=B3)*($C$3:$C$13152=C3)*($D$3:$D
> $13152)));$K$1:$L$6;2;true)
>
> Could someone help me out?
--
On Jul 28, 7:18 am, x-plicit wrote:
> Hello All,
>
> I do not understand this sintax:
>
> =PROCV(sumproduct(max(($B$3:$B$13152=B3)*($C$3:$C$13152=C3)*($D$3:$D
> $13152)));$K$1:$L$6;2;true)
>
> Could someone help me out?
Google implies you've got a Portuguese version with =procv() being
either v
Using an approximate match, find the largest value in (B3 * C3 * each
cell in D3:D13152) located in range(K1:K6) and return the
corresponding value in range(L1:L6)
google indicates you've got a Portugese version of Excel, with
=procv() being either =vlookup().
standard layout is VLOOKUP (lookup_v
