Second search criteria for vlookup function

January 25, 2018 at 05:22:31
Specs: Windows 7
I found in an older post following VBA Code :

Dim Bcell As Range

For Each Bcell In Range("A1", Range("A" & Rows.Count).End(xlUp))

Bcell.Offset(0, 1).Formula = "=Vlookup(" & Bcell.Address & ",KG!C3:R136,2,False)"
Bcell.Offset(0, 5).Formula = "=Vlookup(" & Bcell.Address & ",KG!B3:R136,3,False)"
Bcell.Offset(0, 6).Formula = "=Vlookup(" & Bcell.Address & ",KG!C3:R136,4,False)"
Next Bcell

How would you add a second search criteria (another cell) in the Vlookup function ?


See More: Second search criteria for vlookup function


#1
January 25, 2018 at 06:36:38
Please clarify what you mean by "second search criteria (another cell)".

Are you looking for an OR or an AND or something else for the second search criteria?

Please keep in mind that we can't see your workbook from where we are sitting, nor do we understand your process, so the more detail that you can provide, the better.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Report •
Related Solutions


Ask Question