i am currently working on a workbook where i have a Name fiels Badge number
and phone number. I have successfully used the Indirect function and was able
to get the badge number to display in a cell below when i choose the name
(using a list). Assuming, Name to be in Cell B2, when i choose a name from
the list in Cell B2, The Badge number displays in Cell B3 (used =Indirect(B2)
function)
The data is stored in location B200-B215 (Name), C200-C215(badge Number) and
D200-D215 (Phone Number). all i want is, when i choose the name, the Cell B3
should show the Badge number (which it is doing now) and the Cell B4 should
show the Phone Number. How do i do this