Hey guys, I've got a problem that I'm hoping you can help me with. I need a formula for column G. I want the formula to look at column F, match it up with the data from columns A-D and output the corresponding number.

So for example, in cell G2 I want it to look at F2 and see "a West Brom". Then I want it to search columns A-D for "a West Brom" and find it in A9. Then I want it to look at the corresponding cell (in this case B9) and output the value of the corresponding cell. So in G2, I want it to output 0.93.

Is this possible? If so, can you show me how?

Thanks in advance.

Sample Workbook.xls