Index to return value based on 2 conditions

		Microsoft Office Forums > Microsoft Excel > Excel
Index to return value based on 2 conditions

01-28-2017, 05:11 AM

george batshon george batshon is offline

Windows 10 Index to return value based on 2 conditions

Office 2013

Novice

Join Date: Jan 2017

Posts: 2

Quote:

Originally Posted by Pecoflyer

Hi
in I2 enter =INDEX($B$2:$D$4,MATCH($G2,$A$2:$A$4,0),MATCH($H2, $B$1:$D$1,0)) and drag down

Much appreciated!! it worked!

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to make MATCH/INDEX formula return multiple successive responses.	danigirl121	Excel	7	06-08-2016 01:57 PM
Get Paragraph index from bookmark starting index	vince692	Word VBA	6	05-13-2016 04:51 AM
Return List Based On Specific Value	Helmszee	Mail Merge	1	04-12-2016 02:30 AM
How to Subtract value in table, based on two different conditions	nitemath2	Excel	1	06-19-2015 01:28 AM
Create index based on bullet numbers	EZRider	Word	0	07-10-2009 09:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:50 PM.