Forum Discussion
Trying to assign a number value to non-numerical value but still display the text not number
I am working on a timesheet and I need the cells to show the text like "Morning, Evening, Night" etc but the cell needs to have a numerical value but still show the text, not the value. The numerical...
It's not possible. Use one column for the numbers and another column for the text values.
great thanks for that. I told my coworker this but he said there must be a way....
- They want the user to enter the non-numerical text like "Morning, Evening, Night" and then it will show that on the main page, but when the VLOOKUP is used on the second tab, it puts the corresponding number like 8, 12
try
=IFERROR(VLOOKUP(VLOOKUP(D4,Schedule!A72:B126,2,FALSE),Schedule!$I$71:$J$77,2,FALSE),"")
The blue function find "Morning" or "Evening" or "Night"...
The red convert "Morning" in 8 for exemple
I may not have understood
