Drop down list (cell range) which include data from the row of the drop down list

[Necromancer]

Hello.

I have an spreadsheet file with 2 sheets. the first include the data columns and a comment column from row 2 to 50. The second include the text of the comments (20-30) which I like to use for drop down list but i like to include data from the first sheet in the text, I used the indirect to include the data Indirect(“Sheet1.A”&ROW()). I am out of luck. I can’t generate the drop down list in the first sheet . I try to make the dropdown list which include the text and when select the element of the drop down list in the sheet1 comment column in row x, it will include the specified data from sheet1 of row x. The data is in different part of the text in every comment in sheet2. Somebody can give me an advice how I can do it?

Thanks a lot for any help

Regards

[dscheikey]

@Necromancer

Can you please test the attached document to see if it is what you want. I am not sure if I have actually understood the problem.

Drop down list (cell range) which include data from the row of the drop down list.ods (25,1 KB)

[Necromancer]

Hello.

First of all. Thank you for the answer. There is the file:

Azonosítók.ods

I filled out some data and the Dátum in the comment means the data of the Dátum cell in the same row but if i find a solution I could use different colums from munka1 (as you see for example the Rendszám colums)

Regards
Csaba

[dscheikey]

@Necromancer
I prepared your file as in my example before. I think it does what you want!?
Doesn’t it?

Have fun
dscheikey

Azonosítók.ods (22,5 KB)

[Necromancer]

Hello.

I could solve the problem. The result is at Munka1.U23.
Azonosítók (3) másolata.ods (53.2 KB)

[Necromancer]

Is there any simplier solution?