Cell Next to

  • Thread starter Thread starter Josh
  • Start date Start date
J

Josh

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
 
=VLOOKUP(A1,ws2!A:B,2,FALSE)

--
HTH

Bob

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