cse formula

Trying to use index(match to bring over some data from one sheet to another one. Part of the criteria is based upon text found in a string. I was hoping to just use wild cards but it appears, after trying a few times, that it isn't working. Where am I going wrong? On sheet1 in cell D2 I am...

Long time reader, first time poster. Thanks for all of the quality questions and answers. I am using an Index-CSE Fx to return whole rows of data from a source table (time log) into three separate sub-tables based on a selected "category column" which is my vertical lookup column (i.e. "Port...

This is a table that effectively has the same problem as the one I'm experiencing. <tbody> 100 Blue 1 =PRODUCT(IF(AND($A$1:$A$9>=100,$B$1:$B$9=B1),$C$1:$C$9,1)) 120 Red 2 =PRODUCT(IF(AND($A$1:$A$9>=100,$B$1:$B$9=B2),$C$1:$C$9,1)) 10 Green 3...

On tab "Letters" is a simple table that column A is "Date Letter Sent" and column B is the total number of letters sent on the date listed in column A. (If it is important, not every day will be listed. So Column A can go 9/3/13,9/4/13,9/10/13,9/12/13,9/13/13 etc. If any letters are sent, the...