Enter a cell value to populate a cell value from another tab

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?

• › [Solved] How to populate lastrow and shift cell up in a fixed range?
• › Assigning a value to a cell based on another
• › [Solved] Formula needed to populate a single cell
• › Copy set of values to different cell
• › [Solved] When i entered the cell value should get
• › [Solved] Assigning a value to a string
• › assign value to text(name)