I have a sheet that looks like this with phone #s filled in
a b c d e
home home2 car office office2
1 Tom
2 Bill
3 Steve
4 Harry
5 John

I have created a drop down menu for the names, and a dropdown menu for
the locations. What I want to do, is create a formula or something to
put in a box next to these menus so that when you select, for example,
Tom + home2 it will give you THAT #, and if you select Steve + car it
will give you THAT #, and so on

Any help would be GREATLY appreciated!
Scott