If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
vlookup with 2 criteria or more
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 |
#2
|
|||
|
|||
vlookup with 2 criteria or more
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 |
#3
|
|||
|
|||
vlookup with 2 criteria or more
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.a...excel/200911/1 |
Thread Tools | |
Display Modes | |
|
|