Forum Discussion

jdogg29's avatar
jdogg29
Copper Contributor
Mar 16, 2023

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

Resources