Vlookup or Index/Match - Multiple Criteria

		Microsoft Office Forums > Microsoft Excel > Excel
Vlookup or Index/Match - Multiple Criteria

FAQ

Thread Tools

Display Modes

01-15-2012, 07:31 AM

ruci1225

Windows 7 64bit Vlookup or Index/Match - Multiple Criteria

Office 2010 64bit

Novice

Join Date: Jan 2012

Posts: 2

I Resolved this

For anyone interested, the following formula worked after I figure out how to do it. ((Make sure you make this an array)) F2, CTRL-SHIFT-ENTER rather than just enter after inputting formula.

=INDEX(CallData!$C$2:$C$9,MATCH(1,
IF(ISNUMBER(MATCH(CallData!$B$2:$B$9,$B2:$D2,0)),
IF(CallData!$C$2:$C$9>=$E2,1)),0))

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Vlookup, offset, match & countif	jujuwillis	Excel	2	10-15-2011 11:06 AM
Multiple VLOOKUP's checking multiple Cells	OTPM	Excel	11	05-23-2011 11:18 AM
Vlookup and If conditions together along with match formulas	david_benjamin	Excel	2	04-11-2011 11:30 AM
Moving a Index/Match function	FraserKitchell	Excel	2	01-19-2010 09:38 AM
Multiple criteria in SUMIF?	pumpkin head	Excel	1	02-17-2006 09:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:54 PM.