Microsoft Office Forums - View Single Post - Vlookup two columns return 3rd

Thread: Vlookup two columns return 3rd

View Single Post

Old

01-12-2014, 01:49 AM

Pecoflyer

Pecoflyer is offline

Pecoflyer uses Windows 7 64bit

Windows 7 64bit Pecoflyer uses Office 2010 64bit

Pecoflyer uses Office 2010 64bit

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,920

Pecoflyer has a reputation beyond repute

Pecoflyer has a reputation beyond repute

Pecoflyer has a reputation beyond repute

Pecoflyer has a reputation beyond repute

Pecoflyer has a reputation beyond repute

Pecoflyer has a reputation beyond repute

Pecoflyer has a reputation beyond repute

Pecoflyer has a reputation beyond repute

Pecoflyer has a reputation beyond repute

Pecoflyer has a reputation beyond repute

Pecoflyer has a reputation beyond repute

Default

In B4 :

Code:

=SUMPRODUCT((Sheet2!$A$2:$A$7=Sheet1!B$2)*(Sheet2!$B$2:$B$7=Sheet1!B$3)*(Sheet2!$C$2:$C$7))

drag right and down ( only for row 5)

In B6 :

Code:

=INDEX(Sheet2!$E$1:$E$7,(SUMPRODUCT((Sheet2!$A$1:$A$7=Sheet1!B$2)*(Sheet2!$B$1:$B$7=Sheet1!B$3)*ROW(Sheet2!$E$1:$E$7))))

and drag right

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Reply With Quote