Formula for multiple variable row find

aqibi2000

New Member
Joined
Oct 19, 2017
Messages
9
Office Version
  1. 2013
  2. 2010
Platform
  1. Windows
  2. MacOS
I have been playing with INDEX Match and Vlookup, however am struggling to solve my problem, I normally end up using 10+ multiple column filters to reach my results.

Made an example below where I input 3 variables and wish to find a Row which matches all the criteria, in the example the results would be H.

Would really appreciate the help



Data1.xlsx
ABCDEFGH
1
2Row FoundHRowVar1:Var2:Var3:
3Input Var1:1A024
4Input Var2:3B124
5Input Var3:5C034
6D134
7E025
8F125
9G035
10H135
11
12
Sheet1

Thank you
 
You're welcome & thanks for the feedback.
 
Upvote 0

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Forum statistics

Threads
1,223,897
Messages
6,175,269
Members
452,628
Latest member
dd2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top