Anyway I have a table that
has to use two inputs to distinguish between the records. Therefore, I
need to find a way to do a Vlookup based on two inputs meaning look up A
in table XYZ and then check for what record also corresponds to column
B. If anyone needs more clarification I can add a sample table later.
I already have a pretty in depth code that uses Vlookup to populate a
one table with another so I am looking for some way to correspond this
the current vlookup code that is already there. Thanks



Cells(KeyStartRow, GroupLeadCol).Select

Selection.Formula = "=VLOOKUP(" & Cells(KeyStartRow,
BillCol).Address(RowAbsolute:=False, ColumnAbsolute:=False) & ",'Ref.
Tables'!H:M,4,FALSE)"

'''''''''''now checks for cells(keystartrow, modelcol) = Ref.
Tables'!A:E,2,FALSE if not move to next record

Selection.AutoFill Destination:=Range(Cells(KeyStartRow,
GroupLeadCol), Cells(KeyEndRow, GroupLeadCol))