Copy values from sheet"list" to "invoce" on trigger

[perko121]

Hi All

I have sheet "list" with data that needs to be copied on its place on sheet "invoice". Trigger should be typing number "1" next to column that needs to be copied (J2). and so on (J3,J4,J5...ETC.). It will be only one number 1 at certain time.

I've already written example so you can see where goes certain data.
Also one more thing is that on sheet "list" data from row A1 should be checked at sheet "driver" and displayed at sheet "invoice" (F3)

thank you

[D.Lovell]

Hi,

You can do them all with INDEX & MATCH, each for a different column number, as long as you only have the '1' entered on a single row at a time. I believe if you don't it will return the highest one up in the list where a '1' is entered.

I demonstrated them all on the attached but this one (Index returning column 4 is for G13).

Please Login or Register  to view this content.

I recommend against the use of merged cells where formulas are referring to these cells or in these cells, therefore I have un-merged them, and demonstrated in G13 how you can account for this on the appearance....

Please Login or Register  to view this content.

Wrapped text with the cell formatted as text is also no good if you want to put a formula in it, notice the changes I made.

I think this is what you mean, if not please explain further

Regards,

[perko121]

Thank you so much, this works fine.
still my 2nd question remains unanswered:

"Also one more thing is that on sheet "list" data from row A1 should be checked at sheet "driver" and displayed at sheet "invoice" (F3)"

F3 is dropdown I forgot to remove it so I'm uploading your file with removed dropdown.

regards

[JeteMc]

Paste the following formula into cell F3:

Please Login or Register  to view this content.

Let us know if you have any questions.

[perko121]

Thank you all working fine!

[JeteMc]

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.