Forum Discussion
Help on lookup from a list and then display result based on content
Hi Sergei, When I add in the rest of our data to the accounts tab and then validate the data to the drop down list the function no longer works, do you know why this is?
You mean conditional formatting doesn't work or something else? I added data close to the end, it works. Try to check condition manually at any empty cell
as
It seems to be ok at the top of the sheet but not at the bottom, I tried as you suggested and I get this result
It also doesn't work at the top of the sheet for the second entry of the same name. Does it work for you on yours if you do multiple entries of the same name ?
That only means the values in columns E and AC are different. Perhaps you have extra spaces in texts or other non-printable characters. Happens quite often if copy / paste from others source, especially from Web. Hard to say without seeing concrete values.
In any case, that's not conditional formatting error, that's data is not cleaned.
I'm sure you are right but they look the same, even copied and pasted it so it has to be 🙂
On your end if you put in Able Cleaning into cell E13 it comes up as red in cell G13 (i can see that)
If you put in Able Cleaning into cell E14 does cell G14 fill in red ? Cos mine doesn't