Microsoft Office Forums - View Single Post - Issue with Index and Match logic

Thread: Issue with Index and Match logic

View Single Post

Old

12-04-2014, 09:02 AM

vegasbound365 vegasbound365 is offline

vegasbound365 is offline

vegasbound365 uses Windows 7 64bit

Windows 7 64bit vegasbound365 uses Office 2010 64bit

vegasbound365 uses Office 2010 64bit

Office 2010 64bit

Novice

The original poster

Join Date: Dec 2014

Posts: 2

vegasbound365 is on a distinguished road

Default

Quote:

Originally Posted by Pecoflyer

View Post

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)

Reply With Quote