|I would like to be able to enter a value in one cell and have it populate a value in another based on a 'key' from another tab. Currenlty Sheet1 contains static data but Sheet2 will have values entered related to the data but will be variable. |
For example, if I enter the number 1 in Cell A1, I want Excel to autopopulate B1 with 10.75.
How would I write this formula not using VBA?