Vlookup Help

[Shantaram_c]

Vlookup with Two Condtion

Name Palce qty
AAA ZZZZ 13
AAA yyyy 14
BBB yyyy 14
CCCC yyyy 13

Can i get qty for Name = AAA and Place = YYYY with Vlookup

shantarm

 

[fairwinds]

Hi,

You could do like this:

=INDEX(C1:C4,MATCH(F1&G1,A1:A4&B1:B4,0))

F1 is AAA and G1 is YYYY

 

[Aladin Akyurek]

Yes, by doing a multi-key lookup where you use concatenation wrt the source data...

Book7
	A	B	C	D	E	F	G	H
1	Concat	Name	Palce	Qty
2	AAAZZZZ	AAA	ZZZZ	13		AAA	YYYY	14
3	AAAyyyy	AAA	yyyy	14
4	BBByyyy	BBB	yyyy	14
5	CCCCyyyy	CCCC	yyyy	13
Sheet1

Formulas...

A2:

=B2&CHAR(127)&C2

H2:

=VLOOKUP(F2&CHAR(127)&G2,$A$2:$D$5,4,0)