Ask Your Question
0

Data in Drop-down list constructed from few cells

asked 2020-01-29 22:37:07 +0200

jankowal gravatar image

Hello, i have also second problem. In one sheet i have data with my clients, columns with names, address, phone number, postal code etc. How i can create in other sheet drop-down list with that data, that they could be joined? For example in sheet1 i have something like this:

NAME    ADDRESS PHONE   POSTAL CODE MAIL
John    Kolegien    3333    333-657 mail@mail.com
Kate    Bahrman 2222    444-343 fesfes@blah.com

How to create in a second sheet a drop down list from choosen columns, for example only NAME, ADDRESS AND MAIL?

then i should have something like this in one cell when i choose it from drop-down list:

John Kolegien mail@mail.com
Kate Bahrman fesfes@blah.com

Is that possible to create?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2020-01-30 12:43:37 +0200

Hello @jankowal

You can use Data > Validity menu option to create drop down list with desired entries. I advice to use predefined Named ranges for each column for better readability:

NamedRanges

After creating these ranges select desired cell on another sheet, go to Data > Validity menu option and select Cell range in Allow list. Enter formula name&" "&address&" "&mail as source.

DataValidity

That's all.

result

edit flag offensive delete link more

Comments

Hello @SM_Riga

Thank you very much for your work and time! It works very good :)

Maybe you know if it is possible to display this score in nice looking format? For example i have more columns and i want to display view after choosing given line from drop down list like this:

<First name> <Last Name>

<Address>

<Mail>

Because i see now it depends on changing manual length of column and when for example it will be an address, sometimes part will be in one line, and rest in the other, or if it will be longer it will be in more lines etc.

jankowal gravatar imagejankowal ( 2020-01-30 19:13:14 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-01-29 22:37:07 +0200

Seen: 35 times

Last updated: Jan 30