multiple drop down menu

G

grizzly6969

A41 is a drop down with names from A800 through A818
C41 is a drop down with monday to friday C799 through H799
lets say Bob is in A800 and E800 shows 12 hours -- D799 is a Tuesday
16 hours E799
is a Wednesday etc.
if I Hit drop down box and click on Bob and then hit on the next drop down
and click on Wednesday is it possible to have D41 will display 16 hours
but if I click on Tuesday D41 will display 12 hours
 
T

T. Valko

Apparently none of the suggestions you got last night worked but this
description of your setup is different.
with monday to friday C799 through H799
Click to expand...

Mon to Fri is 5 days but C799 through H799 is 6 cells.

Let's assume the range is C799:G799

Try this formula in D41:

=VLOOKUP(A41,A800:G818,MATCH(C41,A799:G799,0),0)
 
G

grizzly6969

-- Beautiful -- works excellent
thank you
grizz


T. Valko said:
Apparently none of the suggestions you got last night worked but this
description of your setup is different.


Mon to Fri is 5 days but C799 through H799 is 6 cells.

Let's assume the range is C799:G799

Try this formula in D41:

=VLOOKUP(A41,A800:G818,MATCH(C41,A799:G799,0),0)
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

drop down's 2
Print Macro w/drop down list 1
Timesheet with many conditions 4
Usability - drop down box - Arrow INSIDE box? 1
Creating a drop down list based on two cell values 5
Excel Drop down menu IF statement help Please 2
How do I reflect the true finish date for a task? 3
Resetting multiple cells containing drop-down lists 3

Top