Click to Watch in HD > क्यों Vlookup Formula Error देता है एक ही Workbook में यूज़ करते वक़्त

Watch Teachtoeach presents a Video on Why Vlookup Formula Gives an Error While Using in a Single Workbook in Excel in Hind. इस Video के माध्यम से में आपको बताऊंगा की क्यों Vlookup Formula Error देता है जब हम इस को एक ही Workbook में यूज़ कर रहे होते है |Why we use Vlookup Formula ? Vlookup Formula क्यों यूज़ होता है ?Vlookup Formula के द्वारा हम एक value से दूसरे value को match करके उसके right side के Data को Fetch कर सकते है |क्यों Vlookup Formula Error देता है जब हम इस को एक ही Workbook में यूज़ कर रहे होते है ?Vlookup Formula देता है क्यूंकि जब भी हम Vlookup Formula एक ही Workbook की अलग अलग या एक ही Worksheet में लगा रहे होते है तो उस वक़्त Automatically Range Fix नहीं होती है जो की अलग अलग Workbook में काम करते वक़्त Automatically Range Fix हो जाती है . यहाँ हमे खुद F4 Button की मदद लेके Range या Cell को Fix करना पड़ता है |Syntax of Vlookup Formula :-VLOOKUP( value, table, index_number, [approximate_match] )Parameters of Vlookup FormulaValue : The value to search for in the first column of the table.Table : Two or more columns of data that is sorted in ascending order.Index_Number : The column number in table from which the matching value must be returned. The first column is 1.Approximate_Match : Optional. Enter FALSE to find an exact match. Enter TRUE to find an approximate match. If this parameter is omitted, TRUE is the default.It is a very difficult task to anyone. If you are really interested to learn this trick then this video never lets you down. On Youtube, only just few videos are available on why Vlookup Formula gives an error when we are using in a worknook in Excel in Hindi. Thanks for watching. It is humble request to you. Please subscribe my YouTube channel by click on this link. www.youtube.com/teachtoeach Some Popular Videos are :-1) How to use ISBlank Formula in Excel in Hindi - https://www.youtube.com/watch?v=cI5b7_cZr-k2) How to use Indirect Custom Validation in Excel in Hindi - https://www.youtube.com/watch?v=uUndruZkccc3) How to Enter Large Digit in Excel in Hindi - https://www.youtube.com/watch?v=rdAWbOtBLVQ4) Magic Trick - How to Find any Position of Space or Character in Excel - https://www.youtube.com/watch?v=L27XO0SfY8Q5) Motivational Video for Students | अगर CBSE UP Borad Exam में फेल हो गए तो इस वीडियो को देखें - https://www.youtube.com/watch?v=sCZNYSrQE206) What is Objects Methods Properties in Excel VBA in Hindi | Part 4 - https://www.youtube.com/watch?v=T5wnUUe3PyU7) How to Create Class Intervals Auto Fill List in Excel in Hindi - https://www.youtube.com/watch?v=xtUHXo6mXZE8) Excel VBA Editor Tutorial in Hindi - https://www.youtube.com/watch?v=9WjWRUSKwrk9) Nested IF Formula in Excel in Hindi - https://www.youtube.com/watch?v=j-PJTLgRXNY10) How to Record Macro in Excel in Hindi - https://www.youtube.com/watch?v=VJq3ejJMmmw11) How to make Paytm QR code in Excel in Hindi - https://www.youtube.com/watch?v=LQ1srotDpQE12) Excel VBA in Hindi | Excel VBA Tutorial in Hindi - https://www.youtube.com/watch?v=qYfvzzo2ZJg13) IF Formula in Excel Hindi IF Function in excel - https://www.youtube.com/watch?v=OH0SLZUzBv414) How to Find Duplicates Using Vlookup Formula in Excel Hindi - https://www.youtube.com/watch?v=kcYyzIy4rF415) Reverse Name in Excel Hindi - https://www.youtube.com/watch?v=ujs29_MbmQw16) How to split middle name in excel in hindi - https://www.youtube.com/watch?v=KFX2FQbcWFw17) Fill series option in excel - https://www.youtube.com/watch?v=WQ_JBsdHP7o18) How to split first name in excel - https://www.youtube.com/watch?v=r_saghnF6yI19) How to Count Length of All Character in Excel Hindi - https://www.youtube.com/watch?v=fW11_h4DFYA20) Excel Interview Questions | MIS Interview Question | Excel in Hindi - https://www.youtube.com/watch?v=f53IPkk-VJA