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")
Thank you so much, this works just fine for the scale of my project!