ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Functions (https://www.excelbanter.com/excel-worksheet-functions/111213-functions.html)

OUSoonersgirl

Functions
 
This is what I want to do:

For my time cards we have work code #'s and code descriptions.

For ex.
Description Work Code
Wall-Rough 1234567

When I type in the work code I want the description to automatically display
in the cell next to it. Can this be done?

Bob Phillips

Functions
 
As long as you have a table of ids and descriptions, you can use VLOOKUP.
Check help.

--
HTH

Bob Phillips

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

"OUSoonersgirl" wrote in message
...
This is what I want to do:

For my time cards we have work code #'s and code descriptions.

For ex.
Description Work Code
Wall-Rough 1234567

When I type in the work code I want the description to automatically

display
in the cell next to it. Can this be done?





All times are GMT +1. The time now is 05:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com