Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup or index match function
Hi,
I am a novice to intermediate user with vba. I have two worksbooks, one that contains the assignment data and the other that contains the raw data. assignment book (file A) raw data (file B) We currently have a macro that formats file B. I need to modify this macro to look at file A and where there is a match to bring over the person who is assigned the task. We need to match 3 columns from file B with file A, work queue, begin letter range, end letter range. To get the letter range, I am using the left function and pulling the first letter of an account from file B. On file A, certains accounts have subaccounts and that is where the letter range comes in. What would be the best way to perform the matches between workbooks and if possible could you provide me examples. I hope I made sense explaining this. Any assistance would be greatly appreciated. -- Thank you Dave |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup or index match function
Your question would probably be better suited for the programming
forum: http://groups.google.com/group/micro...g/topics?hl=en The focus there is more on VBA. On Jan 29, 9:26 am, Dave wrote: Hi, I am a novice to intermediate user with vba. I have two worksbooks, one that contains the assignment data and the other that contains the raw data. assignment book (file A) raw data (file B) We currently have a macro that formats file B. I need to modify this macro to look at file A and where there is a match to bring over the person who is assigned the task. We need to match 3 columns from file B with file A, work queue, begin letter range, end letter range. To get the letter range, I am using the left function and pulling the first letter of an account from file B. On file A, certains accounts have subaccounts and that is where the letter range comes in. What would be the best way to perform the matches between workbooks and if possible could you provide me examples. I hope I made sense explaining this. Any assistance would be greatly appreciated. -- Thank you Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
index Match, or Vlookup Match.. | Excel Worksheet Functions | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
Index Match Vlookup? | Excel Discussion (Misc queries) | |||
Function Vlookup, Match or Index? | Excel Worksheet Functions | |||
Function Vlookup, Match or Index? | Excel Worksheet Functions |