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 allow data entered only in cells with color
• › Protect row when cell value is not equal to blank
• › [Solved] how do i subtract from a constant cell in excel
• › Excel- Print certain worksheets depending on value of a cell
• › How do I get today's date in a cell, only with text in anoth
• › Is there a formula to skip blank rows in excel?
• › [Solved] How do I use Excel Macros to Copy data to a new tab?