Forum Discussion
Index, Match with an IF statement
Please can I get some help. I may be ignoring the obvious... I am looking to add an IF statement to the end of my INDEX, MATCH formula; if the returned value is 0 the cell is left blank. The ...
If you have Microsoft 365 or Office 2021:
=LET(v, INDEX('27.02.24'!F:F,MATCH(Summary!A60,'27.02.24'!B:B,0)), IF(v="", "", v))
If you have an older version:
=IF(INDEX('27.02.24'!F:F,MATCH(Summary!A60,'27.02.24'!B:B,0))="", "", INDEX('27.02.24'!F:F,MATCH(Summary!A60,'27.02.24'!B:B,0)))