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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks