Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Index to return value based on 2 conditions
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 01-28-2017, 04:32 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Index to return value based on 2 conditions Windows 7 64bit Index to return value based on 2 conditions Office 2010 64bit
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,948
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default
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
Reply With Quote
  #2  
Old 01-28-2017, 05:11 AM
george batshon george batshon is offline Index to return value based on 2 conditions Windows 10 Index to return value based on 2 conditions Office 2013
Novice
Index to return value based on 2 conditions 		 
Join Date: Jan 2017
Posts: 2
george batshon is on a distinguished road
Default
Quote:
Originally Posted by Pecoflyer View Post
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!
Reply With Quote
Reply

Tags
index, vlookup

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Index to return value based on 2 conditions 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
Index to return value based on 2 conditions Return List Based On Specific Value Helmszee Mail Merge 1 04-12-2016 02:30 AM
Index to return value based on 2 conditions 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 08:02 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft