Character

G

Guest

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.
 
G

Guest

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 said:
The 'box' is CHAR(10) which is a line feed.
Why is it in the formula?
Click to expand...
=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,"")
 
G

Guest

Hello from Steved

Please ignore my last reply I have now corrected my problem

Thankyou.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can this formula be placed in VBA please. 3
Surname and First names formula 8
Oracle import 3
Leave cell blank 7
How best to use sumproduct instead of conditional sum: 6
Generate Payment Due Date to exclude Weekends and Public Holiday 4
Referring to a cell by using another cell for the row number 6
SUMIF ?! .... not quite enough.... 4

Top