Hi,

I'm building a IF formula which looks at a date in (sheet 2 F8) and if it matches whats in the (Lookup sheet $P$7) I would want the formula to show what is in (Sheet2 A8) If the date doesnt match what is in (Lookupsheet $P$7) I need it to go down to the next cell and do the same for example.

I hope I examplined it properly, this is the forumula I started I just need the last part fixing.

=if(month(Sheet2F8=Lookup$P$7,Sheet2F1,"I need the formula to go to the next row down if it is false)

Thanks