excel - Use two drop down list selections to get a final value -
i have 2 drop down lists. first employee name , second given calendar week. want able select employee select week , have cell pull hours second worksheet. have drop down lists done can vlookup work week list meaning hours won't change when selecting employee name.
a simple way add column on left of lookup table like:
=i2&"|"&j2
then use like:
=vlookup(a1&"|"&b1,sheet2!$h$1:$k$4,4,0)
in first sheet.
vlookup happy when there single possible answer.
Comments
Post a Comment