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...
Bro I need help
May chata hn serial number daal dn to us product ka name or tamam value show hojay. Dusri sheets sy
May chata hn serial number daal dn to us product ka name or tamam value show hojay. Dusri sheets sy
May chata hn serial number daal dn to us product ka name or tamam value show hojay. Dusri sheets sy
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.