Selecting from list in first cell and need description to pop automatically in next cell

[cwby44]

I have been searching the site for an answer to this question but I can't find one. I have a drop down list with codes in and once I select the proper code I would like the desrciption for that code to fill the cell automatically. I have the codes/description on another sheet in columns right next to each other. I would appreciate any help - I am at a loss.

Thanks in advance

[Tony Valko]

Sounds like you want to do a VLOOKUP.

[cwby44]

That is what I was thinking but I am new to the VLOOKUP function. How would that work?

[oeldere]

Use the help funtion (F1) or use google for video about Vlookup.

Another option is to post an excel file, without confidentional information.

Then we add it in your workbook.

[Kevin UK]

Hi cwby44

Have a look at these sites:
http://www.myonlinetraininghub.com/?s=VLOOKUP

http://www.contextures.com/xlFunctions02.html

[Tony Valko]

Check out the link I posted. There's tons of info plus a video you can watch.

Once you get the hang of it you'll realize that it's actually quite easy.

[cwby44]

Excel timesheet help.xlsx

Here is my sheet - I am looking for help on the Timesheet tab

[Tony Valko]

Enter this formula on the Time sheet in cell C3:

=IF(B3="","",VLOOKUP(B3,Data!A:B,2,0))

Copy down as needed.

[cwby44]

Thank you all for the help. That works perfectly. This is going to save me so much time. I have a new 6 month old and want to spend more time with him and less doing paper work. May have another question or two later - Really appreciate it.

[Tony Valko]

You're welcome. Thanks for the feedback!