Skip to main content

Posts

Showing posts with the label Use of Vlookup in excel

Vlookup in excel to get value from other sheet and use of instr function

Vlookup in excel to get value from other sheet and use of instr function Vlookup example =IF(ISERROR(VLOOKUP(J5,Designation!$B$2:Designation!$D$130,3,FALSE)),"",VLOOKUP(J5,Designation!$B$2:Designation!$D$130,3,FALSE)) =IF(ISERROR(VLOOKUP(G6,EmployeeDetails!$E$2:$F$18,2,FALSE)),"",VLOOKUP(G6,EmployeeDetails!$E$2:$F$18,2,FALSE)) Public Function scut(ctxt As String) As String Dim ind As Integer ind = InStr(ctxt, "0") Dim rstr As String rstr = Mid(ctxt, 1, ind - 1) scut = rstr End Function This is simple example of Vlookup. How to use vlookup in Excel worksheet. =trims(C2) =IF(ISERROR(VLOOKUP(TRIM(B2),EInfo!$E$2:$J$470,6,FALSE)),IF(ISERROR(VLOOKUP(TRIM(B2),EInfo!$F$2:$J$470,5,FALSE)),IF(ISERROR(VLOOKUP(TRIM(B2),EInfo!$G$2:$J$470,4,FALSE)),IF(ISERROR(VLOOKUP(TRIM(B2),EInfo!$H$2:$J$470,3,FALSE)),IF(ISERROR(VLOOKUP(TRIM(B2),EInfo!$I$2:$J$470,2,FALSE)),"",VLOOKUP(TRIM(B2),EInfo!$I$2:$J$470,2,FALSE)),VLOOKUP(TRIM(B