In clients table, edit client name in case it is wrong there);
After that, in Main sheet, select or enter client name anew (You can't enter or select client which hasn't been registered in clients table, and spelling must be exactly same. But beware - you can copy-paste a wrong client name onto main sheet.).

I have a second drop down list and i have problem with the space.
For example if client 1 in Cell(A9) then in Cell(B15) i would like to make a second drop down list with the delivery places (Paris,London,Monaco e.t.c.). But when to
i'm going to do data validation then i get an error message.
As far as I could check, you owe it to the space of the customer's name in the Cell(A9).

Ιs there any way to confuse it;

Thanks

Where you have it? In which table and in which column?. And first of all, in which example file?
In none of currently posted 3 example files (2 yours an 1 mine) exist a table where you can select client in cell A9. And only cell B15 where is something is on Report sheet in my example, and it contains validation list for kind and variety! Do you have some new version of workbook? Then post it! And leave the faulty data validation list or formula in place too - so anyone here can have a look at it.
What does this error message to say?

Good morning,

Please note the file I uploaded now.
I'm going to make the drop down list and type in the bug I have in it cell B7 , but I get it wrong.

Please help me, I don't know what else to try.
Thank you

Attached Files

EXAMPLEEE.xlsx (13.4 KB, 10 views)