Excel: Find a specific cell and paste the value from a control cell into it
- by G-Edinburgh
I have two columns one containing the room number, e.g. B-CL102, the other containing a varying integer.
I want to enter a different, manually determined, integer in a third column.
Whether by macro or native Excel, is there a way to use two control cells at the top of the sheet, type the room number into one and the different integer matching that room into another.
I have minimal experience with macros essentially just the basics.
I tried to use a V-Lookup formula to look at the two control cells (Range) and then fill in the new column, however I don't know how to then fix that value so that it doesn't change when I change the values in the control cells.