Large function

[Netaji]

Hi,

I have the following issue.I have used LARGE function instead of INDEX & MATCH.

The below given function with SINGLE criteria works really well

={LARGE(IF(('RAW DATA'!A:A=C4),'RAW DATA'!E:E),1)}

But the same function with 2 criteria not working.

={LARGE(IF(AND('RAW DATA'!A:A=C4,'RAW DATA'!B:B=K1),'RAW DATA'!E:E),1)}
another way i tried out

={LARGE(IF('RAW DATA'!A:A=C4+'RAW DATA'!B:B=K1),'RAW DATA'!E:E),1)}

Both are not working.I just want to take the single criteria as reference and why it is not working when it comes to 2 criteria..any clue?

Thanks,

Netaji

[FlameRetired]

Try inserting brackets around the conditions.

Please Login or Register  to view this content.

This is logical OR.



To test AND use this.

Please Login or Register  to view this content.

Both array entered of course.

BTW the AND function won't work in array formula such as this.

[Netaji]

Thanks Flame.

Worked like charm.

[FlameRetired]

Glad to hear it. Thanks for the feedback.