Here's what I am trying to do. I have two columns, one with case names
and the other with case numbers. On my spreadsheet, I have a cell with
a drop down box which allows one to choose the case name from a list.
Is there a way that the corresponding case number can be automatically
entered into another cell when the case name is selected?

Thanks for the help!

Joel