I've been searching for a way to make the vlookup function persistent in a cell, or at least find an alternative!
What I am trying to do is make it so that when I enter a value in A1, then B1 automatically references a table and enters a corresponding value. I can do this using vlookup, however once it has found the value, my formula disappears.
I am thinking that a macro could be used to make the cell update the information as needed, but I am not sure how I would program it. Any help would be appreciated!