Forum Discussion
jdogg29
Mar 16, 2023Copper 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!
10 Replies
Sort By
- 我86254Copper Contributor成人激戰官網: www.line86254.com
- jdogg29Copper ContributorIs anyone able to help with this?