Prev: csv, how to set excel to auto load
Next: Stop Scrolling When I double-click cell wall
From: Are on 17 Nov 2009 02:37
Dear Masters

please help me function of vlookup using 2 criteria

A B C
1 X a AB
2 Y b AD

result :
input input result
X a AB

Thanks in advance


From: Jacob Skaria on 17 Nov 2009 02:42
With lookup values in E1 and E2

=INDEX(C1:C10,MATCH(1,(A1:A10=E1)*(B1:B10=E2),0))

Please note that this is an array formula. An array formula can perform
multiple calculations and then return either a single result or multiple
results. Array formulas act on two or more sets of values known as array
arguments. Each array argument must have the same number of rows and columns.
You create array formulas in the same way that you create other formulas,
except you press CTRL+SHIFT+ENTER to enter the formula. If successful in
'Formula Bar' you can notice the curly braces at both ends like "{=<formula>}"

If this post helps click Yes
---------------
Jacob Skaria


"Are" wrote:

> Dear Masters
>
> please help me function of vlookup using 2 criteria
>
> A B C
> 1 X a AB
> 2 Y b AD
>
> result :
> input input result
> X a AB
>
> Thanks in advance
>
>
From: Alan McQuaid via OfficeKB.com on 17 Nov 2009 02:49
Hi,

Take a look at http://www.ozgrid.com/VBA/2-criteria-vlookup.htm

Alan

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/ms-excel/200911/1

 | 
Pages: 1
Prev: csv, how to set excel to auto load
Next: Stop Scrolling When I double-click cell wall