Hi
I’m using the following formula but would like to change it to include more than one result:
=IF(ISERROR(LOOKUP(2,1/(E36:E52<>""),E25:E50)),"",LOOKUP(2,1/(E25:E50<>""),E25:E50))
If for example the existing formula was placed in cell B5 but an additional two results could be...