IF statement using multiple criteria

J

Joe Gieder

First, thank you for any help and please, if this isn't clear let me know.
I have tried this formula in cell J56:
=IF($G56&$J$54='Priced BOM'!$K4&(MONTH(NOW())&YEAR(NOW())+'Priced
BOM'!$Z4),"X","")
this is my data
G56 J54 'Priced BOM'!$K4 'Priced BOM'!$Z4
K-463-12-8 Dec-05 K-463-12-8 6 wks

I have Dec-05, Jan-06, Feb-06 etc. across cells J54 to Q54 and what I'm
trying to accomplish is to match the part numbers (G56) and date (J54) (month
& year) to the value in 'Priced BOM'!$K4 (part numbers are the same) + the
value of today's date (NOW(), month and year only) but add the value in cell
'Priced BOM'!$Z4 which is a number representing weeks and place an "X" under
the corresponding Month Dec-05, Jan-06 etc..
By example the "X" should be placed under the Dec-05 column, if the number
of weeks was 12 it would be under the Jan-06 column.
Is this acheivable?

Thanks you in advance for your help in solving this what I think a difficult
problem,

Joe
 
J

Joe Gieder

I found a solution to my problem, the following formula works:
=IF(VLOOKUP($G55,'Priced
BOM'!$K$3:$Z$131,16,FALSE)="stk","stk",IF($G55&MONTH(J$54)='Priced
BOM'!$K3&(MONTH(NOW()+('Priced BOM'!$Z3*7))),"X",""))
Thank you for looking and if anyone has a better way I would certainly be
interested.

Thank you again
Joe
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top