Welcome to EASY 4U !!! In this tutorial we are going to use Vlookup function with IF function, ISBLANK function, ISNUMBER function and IFERROR function in Excel in HINDI. So, watch the complete video, hope you like it.
=IF(ISBLANK(A10),”Please enter a ID”,IF(ISNUMBER(A10),IFERROR(VLOOKUP(A10,A3:F7,MATCH(B9,A2:F2,0),0),”Record Not Found”),”You have entered invalid input”))
Other Related Videos :-
VLOOKUP with MATCH Function in Excel in HINDI :-
IF Function :-
IF function with ISBLANK, ISNUMBER, ISODD, ISTEXT, ISEVEN, MOD Function in Excel in HINDI :-
VLOOKUP function with IFERROR function in Excel in HINDI :-