0

So I am trying to pull the employee Number from each order. Each order has multiple activity numbers. I need to search based on Column A(Order # ex. 172324), and Column B(Activity # ex 001) to match with the personal number.. Do I use a vlookup for this? Or what would be my function of choice?

With the formula I have now, I am getting #N/A... How do I make it search for both Order # and Activity # in confirmations sheet to return Personal number.

With Range("N2")
 .Formula = "=VLOOKUP(A2&B2,Confirmations!A:G,7,FALSE)"
 With .Resize(Range("A" & Rows.Count).End(xlUp).Row - 1)
IUEthan
  • 9
  • 3
  • 2
    See here: https://stackoverflow.com/questions/42492758/vlookup-using-2-columns-to-reference-another/42493697#42493697 – Scott Craner Feb 08 '22 at 18:24

0 Answers0