I'm looking for an excel command which can lookup data dependent on two
reference columns. eg

A B C D
1 Dave 100
1 A Jim 10
3 C Pete
2 A Alan 30
3 A John Apples
2 B Helen Purple Monkeys

In Cell E1 i would like to enter a value in column A
In Cell F1 i would like to enter a value in column B

So if E1 = 3 and F1 = A then G1 = John and H1= Apples

Any suggestions appreciated


--
Andrew