Vlookup Two values

[matho101]

Hi,

I need to Vlookup column "Grower" and "Variety" to pull through "Total Consigned Volume".

This exact same layout of the 3 columns is present on another tab in pivot form. So I just want to pull the volume across into this table. This table them feeds into a power bi report.

The formula I have tried includes =VLOOKUP(A2&B2,Pivot!T10:V230,3,FALSE) but it just returns an N/A.

Any help will be greatly appreciated.

Grower	Variety	Total Consigned
BACKSBERG ESTATE	DAZZLE
BACKSBERG ESTATE	EMERALD
BACKSBERG ESTATE	EUREKA
BACKSBERG ESTATE	FIRST BLUSH
BACKSBERG ESTATE	MASENA
BACKSBERG ESTATE	SNOWCHASER

 

[Zot]

How your table T10:V230 looks like?

 

[matho101]

Hi Zot

How your table T10:V230 looks like?

Hi Zot:

It looks like below:

grower_name	variety_name	Consigned weight
BACKSBERG ESTATE	DAZZLE	18581.54​
BACKSBERG ESTATE	EMERALD	35344.71001​
BACKSBERG ESTATE	EUREKA	36391.88​
BACKSBERG ESTATE	FIRST BLUSH	23826.9​
BACKSBERG ESTATE	MASENA	19004.26​
BACKSBERG ESTATE	SNOWCHASER	40451.43​

 

[Zot]

There are multiple ways to do LookUp where you need to match two or perhaps more variables. I found this article described it well:

Perform VLOOKUP with 2 lookup values

4 different ways to perform LOOKUP with 2 lookup values We know that VLOOKUP is very useful. At the same time, we know that VLOOKUP has its limitations. E.g. VLOOKUP only looks from left to right; …

wmfexcel.com

 

[Peter_SSs]

Since you have excel 365 and assuming each Grower/Variety combination only occurs once in the lookup table, you could do it simply like this.

21 01 14.xlsm
	A	B	C	D	E	F	G	H
1	Grower	Variety	Total Consigned			grower_name	variety_name	Consigned weight
2	BACKSBERG ESTATE	DAZZLE	18581.54			BACKSBERG ESTATE	DAZZLE	18581.54
3	BACKSBERG ESTATE	EMERALD	35344.71001			BACKSBERG ESTATE	EMERALD	35344.71001
4	BACKSBERG ESTATE	EUREKA	36391.88			BACKSBERG ESTATE	EUREKA	36391.88
5	BACKSBERG ESTATE	FIRST BLUSH	23826.9			BACKSBERG ESTATE	FIRST BLUSH	23826.9
6	BACKSBERG ESTATE	MASENA	19004.26			BACKSBERG ESTATE	MASENA	19004.26
7	BACKSBERG ESTATE	SNOWCHASER	40451.43			BACKSBERG ESTATE	SNOWCHASER	40451.43
Lookup on 2 values

Cell Formulas
Range	Formula
C2:C7	C2	=FILTER(H$2:H$7,(F$2:F$7=A2)*(G$2:G$7=B2),0)