If excel vlookup does not work due to a mistake
What is error in Vlookup
Most of the errors are related to table_array and the col_index_num parameters. Make sure that you are selecting the entire table that you want the formula to reference and not just the column that your lookup value is contained in.
Solution
We have to select the right parameters in table_array and col_index_num which would resolve the issue.
Excel-Xpert is a all about excel, a professional series where everyone would get a chance to participate and we would try to explore and find new things, this would serve people who are keen to learn excel in detail.
Subscribe to:
Post Comments (Atom)
Excel formulas and functions
Excel formulas and functions Formulas and functions are the bread and butter of Excel. They drive almost everything interesting and useful...
-
Excel Dashboards would be covered in our excel tutorial today. We will create Excel Dashboards and learn the following skills in our excel T...
No comments:
Post a Comment