Hi everyone,

I have the following formula:

=IF(OR(ISNUMBER(FIND("M",'CORE Data Quarter'!B19)),ISNUMBER(FIND("L",'CORE Data Quarter'!B19))),'CORE Data Quarter'!A19,"")

What I'm trying to do is add another variable which states if 'CORE Data Quarter'!H19=blank, then 'CORE Data Quarter'!A19,""

On the flip side, if using the same formula as above, if "CORE Data Quarter'!H19 does not equal blank, then 'CORE Data Quarter'A19,""

I've tried:

=IF(AND('CORE Data Quarter'!H19=""),IF(OR(ISNUMBER(FIND("M",'CORE Data Quarter'!B19)),ISNUMBER(FIND("L",'CORE Data Quarter'!B19))),'CORE Data Quarter'!A19,""))

but i get FALSE for all results.

Any ideas?