Excel 2007 : IF AND formula desperate help!!

[markr08]

Hi All!

In desperate need of help with a IF formula, this is what it is:

=IF(C2="Windows",B2,IF((AND(A2=A3,C3="Windows")),B3,IF((AND(A3=A4,C4="Windows")),B4,IF((AND(A4=A5,C5="Windows")),B5,IF((AND(A5=A6,C6="Windows")),B6,IF((AND(A6=A7,C7="Windows")),B7,IF((AND(A7=A8,C8="Windows")),B8,"None")))))))

Here is a link to the spreadsheet (D2 being the formula cell):

http://img199.imageshack.us/img199/8500/29072008.jpg

Basically, I am trying to put the columns data (if it has a porch, conservatory, windows) into one row for the contract number, as the dump which I have, is giving me seperate row's instead of one.

I am trying to get the formula to check if the contract number matches on the following row, and if it does, to check if the Product Description matches the header of that row (if it's a window, conservatory) if so, copy the quantity cell into D1, however, it's copying it even if the contract numbers do not match and I do not know where I am going wrong!!

Can anybody help?

Is there anything wrong with the formula??

Thanks,
Mark

[shg]

Welcome to the forum, markr.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.