Microsoft Office Forums - View Single Post - [Solved] Vlookup or Index/Match - Multiple Criteria

Thread: [Solved] Vlookup or Index/Match - Multiple Criteria

View Single Post

Old

01-15-2012, 07:31 AM

ruci1225

ruci1225 is offline

ruci1225 uses Windows 7 64bit

Windows 7 64bit ruci1225 uses Office 2010 64bit

ruci1225 uses Office 2010 64bit

Office 2010 64bit

Novice

The original poster

Join Date: Jan 2012

Posts: 2

ruci1225 is on a distinguished road

Default

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))

Reply With Quote