Forum Discussion
Solved
Insert a letter from a cell into a IF-function to represent column-letter
Hi, I want to be able to retrieve a value from a cell, which holds a letter, and to use this letter as the column-letter in my IF-function. E.g. I want the "D" in D10 in this function =IF(B10>'Da...
You can use the INDIRECT function for this purpose. Let's say the column letter is in A1.
=IF(B10>INDIRECT("'Datasheet_1'!"&A1&"10");"YES";"NO")
You can use the INDIRECT function for this purpose. Let's say the column letter is in A1.
=IF(B10>INDIRECT("'Datasheet_1'!"&A1&"10");"YES";"NO")
The business logic doesn't exactly shine through this proposed test. There must be better ways of selecting a value for comparison than synthesising direct cell references within a volatile function. For example, it might be possible to pick up the comparison cell using XLOOKUP, or even HLOOKUP on legacy versions of Excel.
We'd have to know more about the setup.