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

Not sure how you got cell B3 to work with the INDIRECT function, but for B4
you can use:
=VLOOKUP(B2,B200:D215,3,FALSE)

-Simon


"Naveen" wrote:

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

=VLOOKUP(INDIRECT(B2),C200:D215,2,FALSE)


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Naveen" wrote in message
...
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

Thanks a lot guys, it worked. Definitely was a great help.
You have saved a lot of work for me.

"Bob Phillips" wrote:

=VLOOKUP(INDIRECT(B2),C200:D215,2,FALSE)


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Naveen" wrote in message
...
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