***WINNERS ANNOUNCEMENT*** June/July 2008 Challenge of the Month

[Aladin Akyurek]

Aladin,

Excellent explanation!

M.

Thanks Marcelo. Much appreciated.

 

[pmp33]

Re: June/July 2008 Challenge of the Month

Here's one possibility.....

=LOOKUP(2^15,SEARCH(D$2:D$10,A2),E$2:E$10)

Hi barry, how would you modify this formula to match multiple columns keyword please, as per below:

 

[Aladin Akyurek]

Re: June/July 2008 Challenge of the Month

@pmp33
Care to post the sample in an Excel readable form? Images requires retying!

 

[Aladin Akyurek]

Re: June/July 2008 Challenge of the Month

Hi barry, how would you modify this formula to match multiple columns keyword please, as per below:

Define BigNum using Formulas | Name Manager as referring to:

=9.99999999999999E+307

C2, control+shift+enter, not just enter, and copy down:

=LOOKUP(BigNum,
   SEARCH(IF($E$2:$E$12=$B2," "&$F$2:$F$12&" ",-BigNum)," "&$A2&" "),
   IF($E$2:$E$12=$B$2,$J$2:$J$12))

 

[pmp33]

Re: June/July 2008 Challenge of the Month

Define BigNum using Formulas | Name Manager as referring to:

=9.99999999999999E+307

C2, control+shift+enter, not just enter, and copy down:

=LOOKUP(BigNum,
   SEARCH(IF($E$2:$E$12=$B2," "&$F$2:$F$12&" ",-BigNum)," "&$A2&" "),
   IF($E$2:$E$12=$B$2,$J$2:$J$12))

I am so so grateful for that!!! This is so great! Thanks so much Aladin, I was working on this for 2 days already!
Much appreciated!! I should have come to mrexcel.com earlier!

 

[pmp33]

Re: June/July 2008 Challenge of the Month

As a thank you present I can provide you a link to a beautiful music I discovered this morning, hope you'll like it:
https://www.facebook.com/video.php?v=736503683056882

 

[Aladin Akyurek]

Re: June/July 2008 Challenge of the Month

I am so so grateful for that!!! This is so great! Thanks so much Aladin, I was working on this for 2 days already!
Much appreciated!! I should have come to mrexcel.com earlier!

You are welcome.

As a thank you present I can provide you a link to a beautiful music I discovered this morning, hope you'll like it:
https://www.facebook.com/video.php?v=736503683056882

Thanks!