Below is a few major Check List to check why HLOOKUP is not working
1. Not Having Lookup_Value in First Row
2. Counting the Wrong Number of Rows for ‘Row_index_number’ parameter
3. Extra Space or Characters
4. Not Using ‘FALSE’ for Exact Matching [Range_Lookup]
5. A new row has been inserted in the old table where HLOOKUP was working
Regards,
Jerry
|