Dropdown List from 3 Lists

[Excelski]

Hello,

Is it possible to create a dropdown list from 3 different lists in different columns

Thanks

Kevin

[oeldere]

You get better help on your question if you add a small excel file, without confidential information.

Please also add manualy the expected result in your file.

To Attach a File:

1. Scroll down to the window below your post Additional Options
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[Excelski]

Okay, here it is.
Thanks for looking
Kevin

[oeldere]

Why not add the columns below each other? (manual).

After that you can use a the datavalidation for G3:g10

[Excelski]

I could do that, but wanted a different solution if it was possible

[oeldere]

How often do you have to change the dropdown list?

[Excelski]

The list will change from time to time, its hard to put a time scale, it could change 5 times in a week and then not again for 2 weeks

[oeldere]

I will look for an solution, but

why are those values in differant columns anyway.

They are imported from other data?

[oeldere]

See the attached file for the result.

several if formula.

[Excelski]

Hi oeldere
Thats great,
NowI just need to understand how it works, but it does!
Thanks
Kevin

[oeldere]

Thanks for the rep.

You're welcome. We appreciate the feedback!

Thanks for marking the question solved.