Iferror with vlookup in excel in hindi | Multiple vlookup with multiple iferror in excel

Поділитися
Вставка
  • Опубліковано 25 сер 2024
  • In this video you will learn how to apply Iferror function with vlookup function in excel in hindi.
    ‪@computorism1508‬
    #function #formula #excel
    You can also watch -
    Weekday function - • Weekday function in ex...
    Custom data validation - • Custom data validation...
    How to marge a large data by using a single function - • Concatenate multiple c...
    Data validation with vlookup - • Data validation with v...
    Insert an object - • How to insert an objec...
    Data validation - • Data validation in exc...
    Dependent dropdown - • Dependent drop down li...

КОМЕНТАРІ • 6

  • @gbgaming9066
    @gbgaming9066 3 роки тому +1

    Bro I need help

  • @gbgaming9066
    @gbgaming9066 3 роки тому

    May chata hn serial number daal dn to us product ka name or tamam value show hojay. Dusri sheets sy

  • @gbgaming9066
    @gbgaming9066 3 роки тому

    May chata hn serial number daal dn to us product ka name or tamam value show hojay. Dusri sheets sy

  • @gbgaming9066
    @gbgaming9066 3 роки тому

    May chata hn serial number daal dn to us product ka name or tamam value show hojay. Dusri sheets sy

    • @computorism1508
      @computorism1508  3 роки тому

      If your question is how to lookup a value by sl no. , than you have to choose the sl no. as a lookup value in vlookup function.
      For an example -
      Sl Products Amount
      1. CPU 100/-
      2. UPS 200/-
      Sl Products
      2 =Iferror(vlookup (A2,A1:C3,2,0),)
      =UPS
      & If you want to lookup the value from another sheet than, =VLOOKUP (A2, go to the sheet & select the range),2,0)
      Don't forget to fix the range
      Hope it will help you.