Forum Discussion
Vlookup Formula Issue
I keep getting #N/A, I am able to get an incorrect category by switching the Age and Category columns. I am trying to use vlookup to see the age in C2, compare it to the chart in O1:P7, and show the category number. Please let me know what I have done wrong.
1 Reply
vintagebigmike I guess your reference table fo getting the category is poorly set up. If you write it like this it will work fine.
