Find data and return data from another cell

[bobgrand]

Hello all,
I have 145 rows of data. Column A is blank, Column B=Suppliers, Column C thru IZ are dates. Each has a different criteria of dates. B1 is Date 01/01/2011, C1 formula is B1+4, D1 formula is C1+4, E1 formula is D1+4, etc. If one of these cells meets the formula Today() I need to have the data from B1 show up in A1 else blank.

Any help would be greatly appreciated.

 

[bobgrand]

Im thinking my first message was too complex. Basically, find Today's date from C1 thru IZ1 and put the value in B1 in A1. If todays date does not match anything from C1 thru IZ1 leave A1 Blank.

 

[Trouttrap2]

Hello,
is this what you're looking for?
=IF(OR(TODAY()=$C$1:$IZ$1),B1,"")

Enter with Ctrl+shift+enter, not just enter.

 

[bobgrand]

I tried that formula and thought that would have worked. I get the #VALUE! in the cell.

 

[Trouttrap2]

Are you entering the formula using

Control+SHift+Enter. It is an array formula and requires all three keys to be simultaneously pushed. Using only the enter key will give you a #Value error. The formula is working for me. Try that first.

 

[Trouttrap2]

I should point out that after entering the formula, it should have the { } brackets surrounding the formula.

 

[bobgrand]

You are correct I guess I just wasn't pressing the keys simultaniously enough.

Thank you for the help. This is big