K
KempensBoerke
A string is put into cell A1 on Sheet1, for example: “This is a larg
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 i
simple, I only one row having following data in cells (th
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 a
result of my VLOOKUP-function. I could put an empty string (“” => tw
double brackets) instead of this 0, by using an IF-function o
whatsoever.
WHAT I WOULD LIKE TO OBTAIN IS THAT CELL B1 ON SHEET1 BECOMES A REA
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 O
SHEET2, THE LARGE SENTENCE FOUND IN CELL A1 ON SHEET1 SHOULD HAVE T
RUN THROUGH THE CELLS B1, C1, ETC... AND DOESN'T STOP AT THE BEGINNIN
OF CELL B1
This last sentence is my real problem. If you have the solution,
would be very grateful.
If you have any suggestions concerning this matter, please post it her
and I will try it out. Maybe I could force something with Conditiona
Formatting??
Thank you in advance
KempensBoerke
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 i
simple, I only one row having following data in cells (th
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 a
result of my VLOOKUP-function. I could put an empty string (“” => tw
double brackets) instead of this 0, by using an IF-function o
whatsoever.
WHAT I WOULD LIKE TO OBTAIN IS THAT CELL B1 ON SHEET1 BECOMES A REA
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 O
SHEET2, THE LARGE SENTENCE FOUND IN CELL A1 ON SHEET1 SHOULD HAVE T
RUN THROUGH THE CELLS B1, C1, ETC... AND DOESN'T STOP AT THE BEGINNIN
OF CELL B1
This last sentence is my real problem. If you have the solution,
would be very grateful.
If you have any suggestions concerning this matter, please post it her
and I will try it out. Maybe I could force something with Conditiona
Formatting??
Thank you in advance
KempensBoerke