Character
Hello from Steved
The below formula works perfectly except if no data it leaves a small square
box which siguests to me it is a character, please how do I modify the
formula below so that this only leaves a clear cell if no data.
=IF(ISNUMBER(MATCH(--$A2,'07, Jan Radio
Log'!$A$2:$A$2000,0)),VLOOKUP(--$A2,'07, Jan Radio
Log'!$A$2:$Q$2000,15,0)&CHAR(10),"")
Thankyou.
|