Cell Next to
 

This is a easy question. I am using Excel 2003. I have worksheet 1 (ws 1)
with a drop down list in column b validated from ws 2. I would like to have
a formula in column c that matches the info to the validated ws and puts the
info in the cell next to it in column c of ws 1.

Thanks

Josh

Cell Next to
 

=VLOOKUP(A1,ws2!A:B,2,FALSE)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Josh" wrote in message
...
This is a easy question. I am using Excel 2003. I have worksheet 1 (ws
1)
with a drop down list in column b validated from ws 2. I would like to
have
a formula in column c that matches the info to the validated ws and puts
the
info in the cell next to it in column c of ws 1.

Thanks

Josh

Cell Next to
 

=VLOOKUP(B1,ws2!A1:B100,2,FALSE)


"Josh" skrev:

This is a easy question. I am using Excel 2003. I have worksheet 1 (ws 1)
with a drop down list in column b validated from ws 2. I would like to have
a formula in column c that matches the info to the validated ws and puts the
info in the cell next to it in column c of ws 1.

Thanks

Josh