IF(OR(ISBLANK( formula not working

[Ramirez07]

I have a formula looking up a month name in cell BT3, once cell BU3 reads a month name in BT3 a formula needs to retrieve the data in cell F3. If cell BT3 is blank then BU3 must also be blank. The months is in a array "MTH" which are from January...December.

[Glenn Kennedy]

In BT3, copied down:

=IF(K3="","",TEXT(K3,"mmmm"))

[Ramirez07]

Hi Glenn

Thank for the comment i appreciate it. I don't have an issue with cell BT3 though, my issue is when there is a month name in BT3 then cell BU3 must retrieve the data in cell F3.

[Glenn Kennedy]

Ah right so.

I'd still get rid of the silly values in BS & BT (formulae in place in sheet) and use this in BU:

=IF(BT3="","",F3)

[Ramirez07]

Super thanks that works like a charm. I do need to keep the silly data in BS and BT for calculating amount of people that visited a specific course on specific month and year. All data will be in one data base and to make a dashboard i unfortunately need this info.
Many thanks.

[mukhtar56]

Dear Ramirez07,

You can use the IF formula twice with instead of writing the Cell Value BT3 you have to use (TEXT(K7,"mmmm") in the formula to get the answer.
I have attached your file with the corrected formula which give right answer in BU3 and BU7. Check the formula in BU3 to BU7 and from there you have just to drag it down.

Thank you,
Regards,
Mukhtar56 (India)

[Glenn Kennedy]

Then back to the first answer, with a tiny tweak:

=IF(K3="","",F3)

It still strikes me as odd that you want a year of 1900 in a dashboard!! But whatever floats yur boat!!!

[Ramirez07]

Hi Mukhtar thanks for this and Mr Glenn have also gave me super valuable input, many thanks and all is working like i need it to be.
Many thanks.

[Ramirez07]

Dear Glenn

Yeah the 1900 showing was also one of the issues due to the cell reads to an empty cell and therefore give the usual 1900 error, but with the formula you gave me that is sorted out.