Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 28th 04, 09:49 PM
KempensBoerke
 
Posts: n/a
Default VLookup resulting in a blank cell...


A string is put into cell A1 on Sheet1, for example: “This is a large
sentence and it doesn’t fit in this cell”.

In cell B1 on Sheet1 I put a VLOOKUP-function:
=VLOOKUP("Item1";Sheet2!A1:B1;2)

On Sheet2, I have a little table for Vlookup-purposes. To keep it
simple, I only one row having following data in cells (the
VLOOKUP-function is not my problem):
Cell A1: “Item1”
Cell B1: “text1”

The following is my problem:

If I blank try to blank cell B1 in Sheet2, I will obtain a zero as
result of my VLOOKUP-function. I could put an empty string (“” = two
double brackets) instead of this 0, by using an IF-function or
whatsoever.

WHAT I WOULD LIKE TO OBTAIN IS THAT CELL B1 ON SHEET1 BECOMES A REAL
BLANK CELL, IF THE VLOOKUP-FUNCTION IN CELL B1 ON SHEET1 RESULTS IN “0”
BECAUSE OF THE EMPTY CELL B1 ON SHEET2. BECAUSE OF THE BLANK CELL B1 ON
SHEET2, THE LARGE SENTENCE FOUND IN CELL A1 ON SHEET1 SHOULD HAVE TO
RUN THROUGH THE CELLS B1, C1, ETC... AND DOESN'T STOP AT THE BEGINNING
OF CELL B1.

This last sentence is my real problem. If you have the solution, I
would be very grateful.
If you have any suggestions concerning this matter, please post it here
and I will try it out. Maybe I could force something with Conditional
Formatting??

Thank you in advance
KempensBoerke.


--
KempensBoerke
------------------------------------------------------------------------
KempensBoerke's Profile: http://www.excelforum.com/member.php...fo&userid=6876
View this thread: http://www.excelforum.com/showthread...hreadid=273418


  #2   Report Post  
Old October 28th 04, 09:57 PM
Frank Kabel
 
Posts: n/a
Default

Hi
you are left with using an IF function or a zero lenght string as a
worksheet function can't returna real blank result

--
Regards
Frank Kabel
Frankfurt, Germany

"KempensBoerke" schrieb im
Newsbeitrag ...

A string is put into cell A1 on Sheet1, for example: “This is a large
sentence and it doesn’t fit in this cell”.

In cell B1 on Sheet1 I put a VLOOKUP-function:
=VLOOKUP("Item1";Sheet2!A1:B1;2)

On Sheet2, I have a little table for Vlookup-purposes. To keep it
simple, I only one row having following data in cells (the
VLOOKUP-function is not my problem):
Cell A1: “Item1”
Cell B1: “text1”

The following is my problem:

If I blank try to blank cell B1 in Sheet2, I will obtain a zero as
result of my VLOOKUP-function. I could put an empty string (“” = two
double brackets) instead of this 0, by using an IF-function or
whatsoever.

WHAT I WOULD LIKE TO OBTAIN IS THAT CELL B1 ON SHEET1 BECOMES A REAL
BLANK CELL, IF THE VLOOKUP-FUNCTION IN CELL B1 ON SHEET1 RESULTS IN

“0”
BECAUSE OF THE EMPTY CELL B1 ON SHEET2. BECAUSE OF THE BLANK CELL B1

ON
SHEET2, THE LARGE SENTENCE FOUND IN CELL A1 ON SHEET1 SHOULD HAVE TO
RUN THROUGH THE CELLS B1, C1, ETC... AND DOESN'T STOP AT THE

BEGINNING
OF CELL B1.

This last sentence is my real problem. If you have the solution, I
would be very grateful.
If you have any suggestions concerning this matter, please post it

here
and I will try it out. Maybe I could force something with Conditional
Formatting??

Thank you in advance
KempensBoerke.


--
KempensBoerke
---------------------------------------------------------------------

---
KempensBoerke's Profile:

http://www.excelforum.com/member.php...fo&userid=6876
View this thread:

http://www.excelforum.com/showthread...hreadid=273418




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Vlookup finds a blank, but returns a zero - HELP! flummoxed Excel Discussion (Misc queries) 6 January 18th 05 04:15 PM
COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. QUEST41067 Excel Discussion (Misc queries) 1 January 15th 05 10:29 PM
Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? Markus Obermayer Excel Discussion (Misc queries) 1 January 4th 05 09:01 PM
Using Jet to read excel file returns blank for last cell - sometim Ron Excel Discussion (Misc queries) 1 December 9th 04 09:21 AM
conditional formatting blank cell TREK5200 Excel Discussion (Misc queries) 1 December 6th 04 03:23 AM


All times are GMT +1. The time now is 04:21 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright ©2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017