Multiple Validations and Lookups

[jalper5]

So i have to come up with a template to show a facility's availability.
the user would first chose the time and city and then the drop down in a cell would display the different facilities that are available at that time.
For example:
choose 06:00 from first drop down, then NY from another drop down. at 06:00 only 2 facilities are available, lets call them Room A and Room B. But if they choose 12:00, then Room A, Room B and Room D are available- so those 3 options are available on the drop down.
i would end up having 4 different locations with maybe 2-6 facilities in each.

how could i go about getting the cell to display the drop down properly.

I have already been playing with vailidations such as =indirect and naming cell ranges to get certain options to appear but i am getting stuck on the "if A and B then C" type thing.
help!
thanks in advance!

[FDibbins]

Hi and welcome to the forum

You probably need to combine your time.city into 1 cell, and then pull the data in based on a match with that, but its hard to suggest anything more without seeing a sample of what you are working with. I would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[jalper5]

Requestform-forum.xlsxRequestform-forum.xlsx

[FDibbins]

Thanks for the file

What I have done, is to move your "time" table off to the side, and replaced it wil a table that will pull out the data for you as (I think) you requested. take a look and let me know what you think?

[jalper5]

i think its getting to the right place, but i only wanted to display in facilities box which ones i have indicated are available.
i will keep looking, thanks for your help. really appreciate it.

[FDibbins]

OK then I dont understand what you want? It sounded to me like you wanted to be able to enter (inthe example I used in your file) 06:00 and New_York, and then have the relevant data shown based on that?

Also, when I 1st looked at your question, I thought you would have had more than 1 occurance of a time, thats why I took the approad I did - seems I was mistaken in my assumption, so try this instead (the results will be identical, just a simpler approach).

In the file I uploaded, in S11, use this, copied down...
=T11&U11

Then in G12, copied across...
=IF(VLOOKUP($D$8&$D$9,$S$11:$Y$202,COLUMN(B$1),0)="","",VLOOKUP($D$8&$D$9,$S$11:$Y$202,COLUMN(B$1),0))


Maybe you can show me a sample of what you expect?

[jalper5]

What you just told me to do worked....now i can just take it and modify i believe with the real data.
you are a life saver!

[FDibbins]

you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)