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...
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
THIS WORKS!! Thank you!
