Hi,
I know this can easily be done with an if function or vlookup, but I was hoping to avoid using formulas just for the neatness and user-friendliness of the sheet.
I'd like a cell to auto-populate based on a another cell's value. I have a list of items, and say from anywhere in column F4:F30, a user enters "EA", I would like the corresponding cell in column G to be filled with "1". I'd like for this to happen on the fly, every time the user enters that value. For any other value that they enter in F4:F30, I'd like the corresponding cell in G to be filled with "Enter Value".

I'm currently achieving this effect with an IF statement, but I'd like for there not to be a formula showing in Column G.

Thanks for the help!