Someone could share a code to do a search on two different sheets using macros
Someone could share a code to do a search on two different sheets using macros
The syntax is:
Application.VLOOKUP(lookup_value, table_array, column_index, range_lookup)
or
Application.WorksheetFunction.VLOOKUP(lookup_value, table_array, column_index, range_lookup)
works in the same way that when you use it in the cells, I give you an example:
Sub FINDSAL()
Dim E_name As String
E_name = "Juan Jones"
Sal = Application.VLookup(E_name, Sheets("NombreDeLaHoja").Range("B3:D13"), 3, False)
MsgBox "Salario: $ " & Sal
End Sub