Hi

I am trying to create a formula that will look in column "b2" which will be a reference to a month i.e Jan
then if the answer is Jan, then look in column "h2",
to see if it contains a "1" (it will either contain a "1" or nothing). If it does i need it to take the value out of column G2 (which will be a number) and paste it in the cell im typing the formula into to.

Hope This makes sense

any help will be greatly appreciated.

Thanks


Submitted via EggHeadCafe - Software Developer Portal of Choice
SharePoint Video Library Template Available For Download
http://www.eggheadcafe.com/tutorials...o-library.aspx