calculating
I am making a telephone bill spreadsheet. I have the look the way I want it,
easy for employees to read. The thing is that with well over 150 employees, I don't like to have to find ext and names every time I do this sheet. What I would like to do, since the extention is there, do something like "if ext # = 106, name = Rose" for all of the employees. This way I can code it once and reuse it, only having to modify new people. How do I do this? |
calculating
Do you have another Sheet or workbook that lists the persons name and
extension? If so you could use the VLOOKUP function to use the ext number on your phone bill to look up the persons name on the other sheet. "justlearnin" wrote: I am making a telephone bill spreadsheet. I have the look the way I want it, easy for employees to read. The thing is that with well over 150 employees, I don't like to have to find ext and names every time I do this sheet. What I would like to do, since the extention is there, do something like "if ext # = 106, name = Rose" for all of the employees. This way I can code it once and reuse it, only having to modify new people. How do I do this? |
calculating
I have a sheet (second page) that has the extentions. I am new to the vlook
up function, can you help me more? "tim m" wrote: Do you have another Sheet or workbook that lists the persons name and extension? If so you could use the VLOOKUP function to use the ext number on your phone bill to look up the persons name on the other sheet. "justlearnin" wrote: I am making a telephone bill spreadsheet. I have the look the way I want it, easy for employees to read. The thing is that with well over 150 employees, I don't like to have to find ext and names every time I do this sheet. What I would like to do, since the extention is there, do something like "if ext # = 106, name = Rose" for all of the employees. This way I can code it once and reuse it, only having to modify new people. How do I do this? |
calculating
Here are my collumns:
Page: Phone Bill Name:A16-A393 AcctCode:B16-B393 Page: Extentions Name:A1-A105 AcctCode:B1-B105 I want to use Phone Bill AcctCode to find Extention AcctCode and return Extention Name to Phone Bill Name "justlearnin" wrote: I have a sheet (second page) that has the extentions. I am new to the vlook up function, can you help me more? "tim m" wrote: Do you have another Sheet or workbook that lists the persons name and extension? If so you could use the VLOOKUP function to use the ext number on your phone bill to look up the persons name on the other sheet. "justlearnin" wrote: I am making a telephone bill spreadsheet. I have the look the way I want it, easy for employees to read. The thing is that with well over 150 employees, I don't like to have to find ext and names every time I do this sheet. What I would like to do, since the extention is there, do something like "if ext # = 106, name = Rose" for all of the employees. This way I can code it once and reuse it, only having to modify new people. How do I do this? |
All times are GMT +1. The time now is 08:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com