Thread: how to display subjects taught by a specific teacher upon selection of the teacher name in a drop down box
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
flummi
 
Posts: n/a
Default how to display subjects taught by a specific teacher upon selection of the teacher name in a drop down box
Here's a proposal:

A1 = validation list with keys in I2:I5 (first col of vlookup table)
B1:E1 = results from vlookup
Formula in B1 copied to C1:E1:

=IF(VLOOKUP($A$1;$I$1:$M$4;J1;FALSE)="";"";VLOOKUP ($A$1;$I$1:$M$4;J1;FALSE))

Lookup table in

0 2 3 4 5
ann math history
ben math history science
carl math science drawing german
peter english drawing german

Reply With QuoteReply With Quote