Issue with Index and Match logic

		Microsoft Office Forums > Microsoft Excel > Excel
Issue with Index and Match logic

FAQ

Thread Tools

Display Modes

vegasbound365 Issue with Index and Match... 12-04-2014, 08:12 AM

Pecoflyer The second argument of match... 12-04-2014, 08:56 AM

vegasbound365 Thank you. Attached is a... 12-04-2014, 09:02 AM

12-04-2014, 09:02 AM

vegasbound365 vegasbound365 is offline

Windows 7 64bit Issue with Index and Match logic

Office 2010 64bit

Novice

Join Date: Dec 2014

Posts: 2

vegasbound365 is on a distinguished road

Quote:

Originally Posted by Pecoflyer

The second argument of match needs a range. This does not work with an IF statement. Please post a sample sheet with what you have and the expected results

Thank you. Attached is a sample of the spreadsheet, with the formula.

Attached Files

Country Rate Match Index.xlsx (10.5 KB, 14 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Index Match function	jackzha	Excel	5	12-03-2014 12:43 PM
Index, match in Pivottable and Pivotchart	Newbies	Excel	0	11-15-2014 12:58 AM
Help with multiple match and index formula	ryanwood	Excel	1	09-12-2012 07:53 AM
Match Index with sumproduct/vlookup	angie.chang	Excel	1	06-18-2012 08:47 AM
Moving a Index/Match function	FraserKitchell	Excel	2	01-19-2010 09:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:33 AM.