Need some help!!!!

ach2ung · May 8th, 2002, 08:43 PM

Hi, I'm trying to make a new payroll workbook. I have the majority of it done, however, I would like to be able to type in a two letter code and have it insert the information into my payroll document. Any idea what would be the best way to accomplish this?

Brian from Maui · May 8th, 2002, 08:55 PM

Try VLOOKUP

Yogi Anand · May 8th, 2002, 08:57 PM

Quote:

On 2002-05-08 19:43, ach2ung wrote:
Hi, I'm trying to make a new payroll workbook. I have the majority of it done, however, I would like to be able to type in a two letter code and have it insert the information into my payroll document. Any idea what would be the best way to accomplish this?

Explore the use of INDEX, OFFSET, MATCH, and VLOOKUP functions. If you post some sample data with what you are trying to accomplish, one could suggest more specific function for the situation.

Regards!

ach2ung · May 9th, 2002, 07:35 PM

Thanks guys, I have tried VLookup today, I think it will do the trick!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 8th, 2002, 08:43 PM	#1
ach2ung New Member Join Date: May 2002 Posts: 2	Hi, I'm trying to make a new payroll workbook. I have the majority of it done, however, I would like to be able to type in a two letter code and have it insert the information into my payroll document. Any idea what would be the best way to accomplish this?

May 8th, 2002, 08:55 PM	#2
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	Try VLOOKUP

May 9th, 2002, 07:35 PM	#4
ach2ung New Member Join Date: May 2002 Posts: 2	Thanks guys, I have tried VLookup today, I think it will do the trick!