Someone asked me to do some updates to a project management file they inherited and I'm running into issues with VLOOKUP.
I have a list of task ID numbers in column A that are set up like this: Look at the cell above and add .01 to it. The result is a a list of numbers 3.01, 3.02, 3.03, etc.
Column E is where I manually type in one of the task IDs and Column F contains the the VLOOKUP.
I know the formula itself works because if I use the Paste Value option to paste a number from Column A into the lookup cell the formula works fine, but if I manually type in the number from Column A, I get #NA.
I tried testing by with =E25=A24, for example, to make sure the values were in fact the same and I get "TRUE". Also, if I manually enter the number in Column A, the formula works.
I'm not sure where to go next. Any ideas?
I have a list of task ID numbers in column A that are set up like this: Look at the cell above and add .01 to it. The result is a a list of numbers 3.01, 3.02, 3.03, etc.
Column E is where I manually type in one of the task IDs and Column F contains the the VLOOKUP.
I know the formula itself works because if I use the Paste Value option to paste a number from Column A into the lookup cell the formula works fine, but if I manually type in the number from Column A, I get #NA.
I tried testing by with =E25=A24, for example, to make sure the values were in fact the same and I get "TRUE". Also, if I manually enter the number in Column A, the formula works.
I'm not sure where to go next. Any ideas?