I have tried everything I can think of on this.
The Formula in cell B2 is:
=VLOOKUP(C2,C6:D38,2,FALSE)
The result should only be a number. For example 100 through 138.
I checked and there are no extra spaces before or after the number. The cell is formated as General. I have also tried formatting the cell as a number.
I am using Excel 2013.
Any ideas? Thanks
The Formula in cell B2 is:
=VLOOKUP(C2,C6:D38,2,FALSE)
The result should only be a number. For example 100 through 138.
I checked and there are no extra spaces before or after the number. The cell is formated as General. I have also tried formatting the cell as a number.
I am using Excel 2013.
Any ideas? Thanks