vlookup

[tintostu]

I'm trying to establish if I can do the following.

Colunm A (Brand info)

Column B (ID Number)


Visited Outlets Stocking Previous Stocking At Stocking After Total Intro's

BRAND A 14B 52 70 50 52 0

BRAND B 14B 52 74 67 68 0

BRAND C 14B 52 57 55 55 0

The info is repeated as above for different ID numbers, therefore I want to use vlookup to identify 'brand a' and 'id number' then I would like it to return column C for example.

Can I do this if so how!!!

Thanks in advance

Stuart

 

[jeffreybrown]

See if this page might help...

http://xl-central.com/lookup-multiple-criteria.html

 

[T. Valko]

I'm trying to establish if I can do the following.

Colunm A (Brand info)

Column B (ID Number)


Visited Outlets Stocking Previous Stocking At Stocking After Total Intro's

BRAND A 14B 52 70 50 52 0

BRAND B 14B 52 74 67 68 0

BRAND C 14B 52 57 55 55 0

The info is repeated as above for different ID numbers, therefore I want to use vlookup to identify 'brand a' and 'id number' then I would like it to return column C for example.

Can I do this if so how!!!

Thanks in advance

Stuart

What version of Excel are you using?

 

[Joneye]

Can you post an element of the work book, possible for lookup or index and match here

 

[tintostu]

Excel 2003

Thanks

 

[T. Valko]

Excel 2003

Thanks

Try one of these:

Book1
	A	B	C	D	E	F	G
2	BRAND A	14B	52	70	50	52	0
3	BRAND B	14B	52	74	67	68	0
4	BRAND C	14B	52	57	55	55	0
Sheet1

Book1
	I	J	K
1	Brand	ID	In Stock
2	Brand A	14B	52
Sheet1

If the value being returned is numeric and the combination of brand + ID is unique:

=SUMPRODUCT(--(A2:A4=I2),--(B2:B4=J2),C2:C4)

This array entered** version will work if the returned value is text or numeric:

=INDEX(C2:C4,MATCH(1,IF(A2:A4=I2,IF(B2:B4=J2,1)),0))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.