On Jul 28, 7:18 am, x-plicit <spinolaang...@gmail.com> 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 vlookup or hlookup.
Standard layout is VLOOKUP (lookup_value, table_array; col_index_num;
range_lookup)
so you've got
=provc(
lookup value;
sumproduct(max(($B$3:$B$13152=B3)*($C$3:$C$13152=C3)*($D$3:$D
$13152))
)
);$K$1:$L$6;2;true
= VLOOKUP (0.1, A2: C10, 2, TRUE)
Using an approximate match, searches for the value 0.1 in column A.
How 0.1 is smaller than the smallest value in column A, an error is
returned (# N / D)
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
