vlookup or index match function

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vlookup or index match 1
With F1 value, look at A, if match or partial match return B 5
Formula Using Vlookup & Match 3
vlookup or index/match formula?? 2
Match & Vlookup Function 1
Excel Trying to do a vlookup with a nested right function on the array 3
IF/VLOOKUP between multiple worksheets 1
If and Vlookup 3

Back
Top