change text to white on blank cell with formula

[justinwb]

Good Afternoon

I am trying to set up 2 cells
Cell J4 has a Formula which shows no test until active
I would like Column K text to be hidden (white) when there is no text shown in Column J once text shows up in J then Column K will return Induct

I have tryed different ways with no luck
=ISBLANK(J4)
=NOT(ISBLANK(J4))

if =IFERROR(VLOOKUP(J4,'[TGL C VUT 485 Driver induction Register.xlsx]Sheet1'!$D$2:$H$35,4,TRUE),"Induct ") needs to be changed to another formula to be able for this to work it was just a simple vlookup


Sorry for got to say Column J will return a date if a date returns as N/A wording will be changed to Induct

Any help would be great
Thank you u
JustinwB

[Bo_Ry]

Please try

=IF(J4="","","Induct ")

[justinwb]

Good afternoon Bo_Ry

sorry It was late at night did not have my sample set up correct
The problem I have is J4 has a vlookup in there
Which is making email to always return induct

I would like induct to hide until a text is shown in the cell

[AliGW]

The cell references you are talking about do not seem to match the workbook you have posted. Try explaining again, but using the sample workbook. Which cell is the one you wish to work on? Why are you returning INDUCT with a trailing space? This may cause problems later.

[justinwb]

Good afternoon AliGW

The problem I currently have is I have a Cell with a =IFERROR(VLOOKUP(V2,Drivers!H:I,2,FALSE),"") when it finds a value it returns a phone number if there is no value to find the cell stays blank
I'm trying to place a cell to the right where if this cell is blank (formula being returning is blank ) for induction word to show up if the phone number does show up in the cell then a vlookup will match
the phone number to another sheet stored on our server and return a date

When trying to set up the sample sheet I tried to made it simple and must of missed a step

let me know and I can we do the sample and do a mock up of all the cells

[AliGW]

Then your solution in the cell to the right will be:

=IF(cell_containing_blank="","INDUCT",vlookup_to_match_phone_number)

[justinwb]

Good afternoon AliGW

I have uploaded one of my running sheets and deleted everything from there only left the stuff we need which has 1 macro

the date sheet currently works when you type a rego in column W then double left click in V cell next a popup list will show with all drivers with this rego once a name is picked there phone number will show up in Column X


When a driver arrives on site we are holding all drivers inductions in a sheet driversinductions

In Column Y when it looks in to Column X if there is no text Cell Y will be white nothing showing
if Column X returns a number it will to a lookup the information on driversinductions if this number is found it will return expiry cell (Column E)
if the phone number does not match any where on driversinductions the cell will return not inducted

Hope this helps I have tried using vlookups and conditional formatting and I cant seem to get Column Y to be white text when nothing is in X only the formula


I have placed a sample in Rows 14,15,16,17 V,W,X,Y
any help would be great

[AliGW]

Try this:

=IF(X14="","",IFNA(VLOOKUP(X14,driverinductions!$D$2:$E$11,2,TRUE),"NOT INDUCTED"))

[justinwb]

Thanks AliGW

When I used my sample group it was working great

Once I start to place new phone numbers e.g 11111 then it returns the last date on the list and does not return Not Inducted

[AliGW]

Then you need to provide a more representative sample. Somehting is causing the issue that we can't see and therefore can't guess at.

[justinwb]

Good afternoon AliGW

After trying everything to work out why this was not working I missed one thing that now that I just found it I fell so dumb

=IF(X14="","",IFNA(VLOOKUP(X14,driverinductions!$D$2:$E$11,2,TRUE),"NOT INDUCTED"))

TRUE needed to be false for exact match when it was set at true it was returning half the wrong info as there was missing lines and other weird stuff it was doing

I will have to kept a note to self also make sure this is set to false

Thanks again for all your help

JustinwB