Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Character
The 'box' is CHAR(10) which is a line feed.
Why is it in the formula? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Steved" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Character
Hello Bernard
I copied the formula from another worksheet hence the reason for CHAR(10) Question I've now taken it out but it now returns a 0, with the below formula what is needed please to have a clear cell Thankyou. =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,"") "Bernard Liengme" wrote: The 'box' is CHAR(10) which is a line feed. Why is it in the formula? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Steved" wrote in message ... 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,"") Thankyou. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Character
Hello from Steved
Please ignore my last reply I have now corrected my problem Thankyou. "Steved" wrote: Hello Bernard I copied the formula from another worksheet hence the reason for CHAR(10) Question I've now taken it out but it now returns a 0, with the below formula what is needed please to have a clear cell Thankyou. =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,"") "Bernard Liengme" wrote: The 'box' is CHAR(10) which is a line feed. Why is it in the formula? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Steved" wrote in message ... 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,"") Thankyou. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Character Map | Charts and Charting in Excel | |||
Excel-Match 1st text character in a string to a known character? | Excel Worksheet Functions | |||
Can I create a special character for the Character Map? | Excel Discussion (Misc queries) | |||
* Character | Excel Worksheet Functions | |||
RIGHT of character | Excel Worksheet Functions |