Really struggling to create this excel formula....

The text within cell A8 of "Legacy CRM Contracts - Working" sheet needs to match the text in column A of "Payment Frequency" sheet

And there is an 'x' in column O of "Payment Frequency" sheet then return the associated value found in column Z of "Legacy CRM Contracts - Working" sheet

And there is an 'x' in column Q of "Payment Frequency" sheet then return the associated value found in column AC of "Legacy CRM Contracts - Working" sheet

There will an 'x' in either column O or Q within the "Payment Frequency" sheet. Not both. But I need the formula to look at both columns and match to the name.

I have tried formula: =IF(AND(ISNUMBER(SEARCH("x",'Payment Frequency'!O:O)),'Legacy CRM Contracts - Work (2)'!A8='Payment Frequency'!A:A),Z:Z,IF(AND(ISNUMBER(SEARCH("x",Q:Q)),A8=A:A),AC:AC,""))

But this does not work and I just get blanks.

I have also tried: =IF(ISNUMBER(SEARCH("x",'Payment Frequency'!O:O))*ISNUMBER(MATCH(A8,'Payment Frequency'!A:A,0)),'Legacy CRM Contracts - Work (2)'!Z8,IF(ISNUMBER(SEARCH("x",'Payment Frequency'!Q:Q))*ISNUMBER(MATCH(A8,'Payment Frequency'!A:A,0)),'Legacy CRM Contracts - Work (2)'!AC8,""))

But this gives me a spill error.

PLEASE HELP.