Need help with Excel formula

Greeting Experts

I need to use an excel formula to match up two different values in an array in a different worksheet (with matching values in Colloms A and Colloms B ) and then output the result from Collom C. Can Somebody help me with this

Example

Microsoft OfficeMicrosoft Excel

Last Comment

Mike

8/22/2022 - Mon

Flyster

10/25/2021

This formula should work for you:

=IFERROR(INDEX($C$2:$C$5,MATCH(1,(B8=$A$2:$A$5)*(C8=$B$2:$B$5),0)),"No match")

Open in new window

It is an array formula so when you enter it you will need to select Ctrl+Shft+Enter.

Paul

byundt

10/25/2021

Although it is possible to build a VLOOKUP formula that will return the desired value, it is better to use an INDEX & MATCH array-entered formula. Doing so avoids the need to concatenate your table and lookup value.

=INDEX('Sheet2'!C$2:C$5,MATCH(1,('Sheet2'!A$2:A$5=B8)*('Sheet2'!B$2:B$5=C8),0))

Open in new window

ASKER CERTIFIED SOLUTION

Rob Henson

10/26/2021

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

Mike

3/10/2022

ASKER

Thanks

Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!

Certified Expert Program

Credly Partnership

Udemy Partnership