The first thing I notice is that your indexed range is not correct, you should index A2:C7. A quick solution I can think of is if you add an additional column that concatenates column A and column B, the formula would be =CONCATENATE(A2,B2), and then you drag it down up to your last row of data, then use. Let's say you put the CONCATENATE formula at column C, this will move the salary to column D. then you will have to use =INDEX(A2:D7,MATCH("Name",C2:C7,0),4)