Reference the value of a cell that is obtained through a function

SamuelDrescher61351

I have cell one that has a function in it say IF(1=1,true,false) and it outputs true. I then want to do a vlookup for that true value, but I keep getting that no such value exists. I assume that's because the cell actually contains the formula rather than the value true. Is there a way to reference just the outputted value?

Paul Newcome

I haven't had any issues with this. Are you able to post a screenshot and the exact formula you are using?

J. Craig Williams

re: "If row_num is set to zero, INDEX returns an array of values for the entire row. To use these array values, you can enter the INDEX function as an array formula in horizontal range, or feed the array into another function."

That is Excel and does not apply to Smartsheet's INDEX() function, at least as far as I know.

Craig