Index to return value based on 2 conditions

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

FAQ

Thread Tools

Display Modes

01-28-2017, 04:32 AM

Pecoflyer

Windows 7 64bit Index to return value based on 2 conditions

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,920

Pecoflyer has a reputation beyond repute

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

__________________
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

Tags

index, vlookup

« Previous Thread | Next Thread »

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 11:38 PM.