Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 519

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Character Map	k f h	Charts and Charting in Excel	6	February 21st 08 05:27 PM
Excel-Match 1st text character in a string to a known character?	bushlite	Excel Worksheet Functions	2	January 15th 07 06:36 PM
Can I create a special character for the Character Map?	JohnP	Excel Discussion (Misc queries)	3	December 24th 06 01:10 AM
* Character	Kevin	Excel Worksheet Functions	1	June 24th 05 06:52 PM
RIGHT of character	Ivor Williams	Excel Worksheet Functions	2	June 22nd 05 09:45 PM

All times are GMT +1. The time now is 06:46 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us