Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help on Indirect function
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using INDIRECT in INDEX(LINEST.. ) function | Excel Worksheet Functions | |||
include INDIRECT function into SUMPRODUCT formula | Excel Worksheet Functions | |||
Using Indirect Function | Excel Worksheet Functions | |||
INDIRECT function question | Excel Worksheet Functions | |||
Indirect( ) function loosing values when spreadsheets are closed | Excel Worksheet Functions |