Solved

# Index w/ Match variables

Posted on 2013-11-18
206 Views
Hello,

The formula I'm using is:

=index(WR!A:G,match(A1&A2,WR!A:A&WR!F:F,0),2)

This works fine so long as the values in A1 and A2 are fixed values.

But what I'd like to do is replace A2 something that says "anything greater than zero." Fiddling with the match_type just returns the wrong values.

Seth
0
Question by:IntegriNet
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 2

LVL 23

Accepted Solution

NBVC earned 500 total points
ID: 39657756
Try changing it around like so:

=INDEX(WR!A:G,MATCH(1,INDEX((WR!A:A>0)*(WR!F:F=A2),0),0),2)

note, this formula doesn't need CTRL+SHIFT+ENTER confirmation, but it is an array formula and so you should minimize the range sizes for better efficiency.
0

LVL 23

Expert Comment

ID: 39850021
Hi Seth,

I was wondering if you tried this solution and if it was successful?
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

### Suggested Solutions

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
###### Suggested Courses
Course of the Month5 days, 6 hours left to enroll