Auto populate a third cell, based on data from two columns

[12ogboy78]

I have data in three columns

A B C
4.5 9.50 4.657
4.5 11.60 4.789
4.5 12.50 4.654
4.5 13.50 3.930
4.5 15.20 3.826

I need to be able to auto-populate the cell in column G based on values in columns A & B. If I type 4.5 in E2, and 13.50 in F2, G2 should auto-populate with the value from column C

E F G
4.5 13.50

Thanks

[FDibbins]

Hi

Try this array formula...
=INDEX($A$1:$C$6,MATCH(E1&F1,A1:A6&B1:B6,0),3)
It has to be entered using CTRL SHIFT enter, not just enter

[Careless]

Hi , try this
20130325 Auto populate.JPG