I have an array that needs some help.
{=INDEX($B$6:$B$500,MATCH(1,($C$6:$C$500=$BD7)*($AY$6:$AY$500=$BC7),0))}
For this array, it needs to also check for a 'Yes' in the range AZ6:AZ500 to be valid
I have an array that needs some help.
{=INDEX($B$6:$B$500,MATCH(1,($C$6:$C$500=$BD7)*($AY$6:$AY$500=$BC7),0))}
For this array, it needs to also check for a 'Yes' in the range AZ6:AZ500 to be valid
Last edited by x65140; 06-02-2014 at 07:12 AM.
Try
Formula:Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Sometimes I just over-think things and make them more difficult. Of course that's it.
Thanks!
..................................
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks