Forum Discussion
jdogg29
Mar 16, 2023Brass Contributor
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 value then gets pulled onto another sheet by the date which I I did this with
=IFERROR(VLOOKUP(D4,Schedule!A72:B126,2,FALSE),"")
Here is the first sheet that needs to display the text not the numerical value. Like we would want it so that if say "Morning" was typed in, 8 hours would go to the other sheet using the VLOOKUP in cell :
This is the second sheet that the numerical value gets pulled to using the VLOOKUP by the date:
Is this possible? thanks for the help!