Alright Forum Folks,

So, I have a table in excel which is lined via a Query file to a SharePoint document library. This is a one way communication and that is fine. The data is being exported to excel for reporting purposes. I am using array formulas to generate new tables using the raw table data. The formulas I have work great except for one issue that I cannot solve. Example below:

Lets say I have a column of numbers in my linked table. [1,2,3,4]. When I reference them using an array formula, they show up as {"1","2","3","4"}.

So if I say {=IF(Table[Numbers] = "3",TRUE)} then it will return {FALSE,FALSE,TRUE,FALSE}

But lets say I assign the conditional "3" above to cell C1. This does not work. The formula errors out. I have tried with quotes, without quotes. I have tried setting the tables column to Numbers in formatting.. nothing. The issue this presents is that I want the conditional inside the IF statment to be changeable via a drop down box. Can anyone provide any assistance here?

Thanks,
Ludeth