Thread: Character
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steved Steved is offline
external usenet poster
 
Posts: 519
Default 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.