Cell Next to

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
 
B

Bob Phillips

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

--
HTH

Bob

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Lookup 2
How to call a worksheet (as a function) 18
Macro to email to address in cell reference 1
Sort multiple columns on all worksheets 2
Look up information on one worksheet and transfer to another 3
Min? 3
Macro to populate same cell on multiple worksheets 1
Worksheet - Copy rows 1

Top