Search results

i have to split what is in one cell number+description in 2 cell one for number one for decription. i use the description for the dropdown, and with vlookup i get the number associated. It is very easy task like that...but if only want to see the code i really don't know

see this is the file from the bank the first sheet contain all the second sheet has been filtered, and they are all "negative"(outgoing" movement. Beside each of the movemente i need to assign those code/description

th excel file work fine, you need to go to data entry sheet and in E2and F2 you'll find a dropdown menu Meanwhile i made a step ahead, if i select the description in the mainlist, i can get in another cell with the vlookup the number associated. I don't know how it will be with the dependend...

Here itr is wht i have to know The data sources ar ein tje 2nd sheet, the first 2 columns are the original datas source both for main and dependant list. In the column d are the data i use for the dorpdown.these are the main In columns f and on are the data i use for the dependencies You see...

I never have that link, i refer to your google search link and i have used other link. I have already used the multi word value, but it is not the same of what i have explained before., if i understood well. Helper and vlookup may be is different.thing which i have to explore yet. I ll prepare a...

update: i need to go more complex the item in the 2 lists, main and dependent are in this frm 000001 description 0000002 description and so on What i need in both list, when choosing data, is the possibility to see the description but actually store only the number Now it is stored the whoòe...

ok yes even that part has hot a small error in the formula SUBSTITUTE, where they use , insted ; May be an easy thing for excel expert but not for someone wh need tutorial to learn :) Anyway, ,i am happy a learn a very nice and useful task. Thanks! How do you think i could add those things in...

they just don't specify clearly that the name of the items contained in the first dropdown, must exactly match the name of the cell containg the dependent list. They do it without saying that this is a crucial step, so on emay think can give a different name. But it is crucial to create the...

ok eventually i sdone it.none of the tutorial says correctly what to do exaclty

getting mad..seems so easy, i follow stepby stepbut the dependent dropdown don't give rresults

ok i amfollowing those site for excel instructions made a step forward, did not know that command are initalian, so i need to use indiretto instead of indirect But after that i receive the error "The Source currently evaluates to an error. Do you want to continue?" that also the site say it...

ys, these are 2 part..this one is the most important, the import caneventually be donemanually, copy paste from file to file

i am testing and seems nodifficult, but may be there is an errror in that procedure? i can go right till the main dropdown list When i create the dependency dropdown using the indirect command in the validation data, i get an error For what i see the name of the list "fruit" and "vegetables" are...

you mean you found the solution with google? i did not even know how to search..don't know how to name this

where do i find the edit for excel?

google sheet is not bad at all i ll give alook at it

hope can be done..but i see no help till now..looks like it is not easy..miay be a workaround?somehting similar?

i make a scheme for a better example: this is the sheet where i got the data to look for, sheetB TYPE SUBTYPE color blue red material concret wood now on another sheet, SheetA i have 2 column that i need to fill from SheetBe. What i think it should be a dropdwon that look...

hey are too hard for me

it is not easy..it is a company , and those are report for the expenses..and it is very rare or impossible that the same day they do the same buy, same description, same amount... But for example the royalties for every money transfer looke just the same..so in the same days could be 2,3,4 or...