Index look up with multiple matches - works for one sheet, not another.

[gr8whtd0pe]

I'm banging my head against my desk here. I know this works. I'm using it on one worksheet in the book and trying to do it on another one and I'm getting nothing but "#N/A".

Please Login or Register  to view this content.

1	2	2.31551	1
1	2	1.90862	2
1	2	2.33591	3

That SHOULD return 2.31551 from column 3, but it's not. Gah. Any ideas as to why its not? If I do MATCH90, it will return that value, but it also returns that value for any variation of the formula so that won't work.

The next line below it would just be:

Please Login or Register  to view this content.

etc.

[AlKey]

It is rather difficult to tell what your formulas are about. However, if (SQL!A2:A50="1" is a numeric value you should remove " " around it.

[gr8whtd0pe]

It is rather difficult to tell what your formulas are about. However, if (SQL!A2:A50="1" is a numeric value you should remove " " around it.

Wow. That was embarrassingly simple to fix.

[AlKey]

You're welcome. Please don't forget to thank those who helped by clicking on Add Reputation * and please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).