VLOOKUP Common errors fixed

Hey Excel enthusiasts, in today's tutorial we're diving into how to fix common VLOOKUP errors that may result in returning wrong data.
The first step is to verify if the lookup value is actually found in the first column of your table.
If it's not in the table, you can add a function to return a alert message. For this add function IFNA in the beginning, then open bracket, then add a comma at last, then twice double quotes with the text in it and close bracket.
Second, ensure column is sorted.
The LOOKUP requires the first column of your table to be sorted in ascending order for approximate matches.
If your data isn't sorted correctly, VLOOKUP may return wrong results.
So sort the first column going into sort option.
Third, Check data type and check for data type mismatches.
If the lookup value and the values in the first column of your table are of different data types, for example text versus numbers, VLOOKUP may not work as expected.
To fix this, convert data types as needed by going to Home tab.
Then numbers group. Select number format.
Thank you.