vlookup in vba not working

Hi all,

I'm writing a macro where I'm using vlookup to find related data. In column F, I have order numbers and column G holds integers that relate to each order number (being broad for security reasons). I'm trying to take each order number from column F and find it in column B. Then I take the related integer in column G and multiply it by a number in column C that related to column B.

Every order number shows up in G, but not all appear in B. This is by design since the order only appears in B if it has a problem. This is why I can't just offset over to the values I need.

I've gotten far enough to grab the value in F and search in B, but in the vlookup parameters, when I type 2 to navigate to column C, my code just returns null even when there is a value there. When I type 1 instead of 2, it properly returns the order # from B, but it won't work when I use 2.

Any hints? If it makes a difference, columns B and C and columns G and F are separate pivot tables.

THANKS!

You're doing this in VBA? Are you using Application.WorksheetFunction.Vlookup? If so, and that looked like

v = Application.WorksheetFunction.Vlookup(arg1, arg2, 2, 0)

try the following instead.

Dim k As Variant
k = Application.Match(arg1, Application.WorksheetFunction.Index(arg2, 0, 1), 0)
Debug.Print arg1, k, arg2(k, 1), arg2(k, 2), TypeName(arg2(k, 2))

That prints values to the Immediate Window. What appears there?