help with a formula

[Redboxsurveys]

Hi i'm completing a simple spreadsheet and am looking for a bit of help with a formula. Basically i want to know what formula to use in this scenario: i have a list of names in column A, and a list of corresponding hourly rates in column B. I Then have a drop down list on a second sheet to choose one of the names in Column A.  I want a formula that when i say choose the name in cell A4 it automatically inserts the hourly rate that is in b4, however that must transend accross the full list so for instance if i choose A3 it inputs b3's rate instead - can anyone help?

[#2]

@Redboxsurveys The thing you're looking to do is called a lookup.  There are various functions for doing it - XLOOKUP is the best one but it's only in the newest versions of Office 365.  In older versions I'd recommend using INDEX MATCH, like this:

    =INDEX(column of hourly rates, MATCH(dropdown cell, column of names, 0))

[#3]

@Savia The Index formula worked perfectly, many thanks