Karimah
11-03-2008, 05:29 AM
Hello Everyone,
I would like to request assistance with vlookup. I have searched this and other forums on vlookup, index and match and have had no success.
I have four sheets that I will be working with.
1. On the first sheet I need to be able to type in a customer number and have the customer data populated from the the second sheet, which contains all of the customer information. The sheet goes from a2:ax2000
2. On the third sheet, I need to be able to populate those fields from the second sheet, which contains all the data.
3. On sheet number 4 I have a word document that I will need to copy, paste and format into excel. It has fields for name, address, city, state, zip and a code that needs to pull a percentage from sheet 3. What is the easiest way to get this done?
Any assistance will be greatly appreciated. Thank you in advance:hi:
I would like to request assistance with vlookup. I have searched this and other forums on vlookup, index and match and have had no success.
I have four sheets that I will be working with.
1. On the first sheet I need to be able to type in a customer number and have the customer data populated from the the second sheet, which contains all of the customer information. The sheet goes from a2:ax2000
2. On the third sheet, I need to be able to populate those fields from the second sheet, which contains all the data.
3. On sheet number 4 I have a word document that I will need to copy, paste and format into excel. It has fields for name, address, city, state, zip and a code that needs to pull a percentage from sheet 3. What is the easiest way to get this done?
Any assistance will be greatly appreciated. Thank you in advance:hi: