Conditional Formatting Formula and Arrays Formulas

Hi All,
I have an dummy formula that WORKS as an array formula (punches out true and false in the right spots) when entered into the cell and dragged, but cant seem to get it to work as conditional formatting.

Every time it says there is an error with the formula, tried entering it normally, using the ctrl+Shift+enter method and with the curly brackets manually

column C contains the value to lookup on table 2, row 2 is the data it wants to match to the data on table 2 (in the 15th to 55th column)
extra if statement to not produce errors is column C is blank,

dummy formula in G5:
=IF($C5="",FALSE,OR(G$2=VLOOKUP($C5,table2,(15:55),FALSE)))

as an array formula so Ctrl+Shift+Enter, should look like
{=IF($C5="",FALSE,OR(G$2=VLOOKUP($C5,table2,(15:55),FALSE)))}

Any ideas?
Edit: Using office 365 Excel Version 1909 (build 12026.20334) Monthly Channel
Edit 2: the 15:55 in the actual dummy formula are named values corresponding to the start and end of what it is trying to match
Edit 3: sample file uploaded

Without seeing your sheet we can keep guessing.
A couple of tips : CF considers formulas as array formulas by default. No curly braces needed
The IF function is implicit in CF, so it is not needed either

Please upload a workbook or a representative cut down copy, anonymized if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.

OR(G$2=VLOOKUP($C5,table2,(15:55),FALSE))

What are your ORing this with?
This is not how to use OR

OR(A1="Black"1,A1="White")

If A1 is Black or White then return TRUE

You have only one parameter in your OR() formula G$2=VLOOKUP($C5,table2,(15:55),FALSE)

Found this:
"Conditional formatting will not look at other tabs in your sheet directly (and don't even think about looking at another file), you must use the INDIRECT function to reference a different tab within your sheet."
on this page: (url removed until i am allowed to by site), by KarlS.

Does this explain why the dummy formula works and the conditional formatting doesn't?
If so how would i go about solving this?

Edit: when using below the formula ,on the sqample file
OR(G$2=VLOOKUP($C5,indirect("table2"),(re1_:re13_),FALSE))
the dummy formula works for putting out true and false in the correct spots, but not when attempting to use this as a CF formula. It gives the error "You may not use reference operators (such as unions, intersections, and ranges) or array constants for Conditional Formatting Criteria.
Edit2: re1_ and re13_ are named values.
the Conditional formatting seems to now have an issue with the 're1_:re13_' part whereas using it as a dummy formula doesnt?

do i have to do it all individually? i.e. =OR ( G$2= VLOOKUP($C5,indirect("table2"),(re1_),FALSE, G$2=VLOOKUP($C5,indirect("table2"),(re2_),FALSE, ... ))
... would continue all the way to 'G$2=VLOOKUP($C5,indirect("table2"),(re40_),FALSE,'
in the actual data (not the sample sheet)

I feel as if your best option is going to be to use rows 10:12 as helpers, which may be moved and/or hidden for aesthetic purposes, then conditionally format rows 13:15 using: =C10=TRUE
Sorry not to be of more help.
Let us know if you have any questions.