I have a really, really simple vlookup formula that has been working, but for some reason has stopped.
The function is to take data validation using "Pass", "Started", "None" and assigning a value to them of Pass = 20 Started = 10 None = 0
The formula is
=VLOOKUP(F35,Data!L27:M29,2)
But when I enter the value of None in the drop down table I get an #N/A error.
It was working an hour ago, I closed the document and reloaded and now it wont work.
Any help please
The function is to take data validation using "Pass", "Started", "None" and assigning a value to them of Pass = 20 Started = 10 None = 0
The formula is
=VLOOKUP(F35,Data!L27:M29,2)
But when I enter the value of None in the drop down table I get an #N/A error.
It was working an hour ago, I closed the document and reloaded and now it wont work.
Any help please