=INDEX(C1:C4,MATCH(1,(A1:A4=F1)*(B1:B4=G1),0))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Puzzled Percy" <Puzzled wrote in message
...
I'm trying to select a value from a table based on 2 variable references.

If been looking at using a VLOOKUP function to do this but because there
are
2 dependant references I'm a little stuck. I thought that maybe a VLOOKUP
with a MATCH function incorporated might be an option as the entries in
each
column are not unique.

To give you an example of what I am trying to achieve I done the table
below.

Basically if F1=9 & G2=2 then select C1 (*)

A B C D F G
1 9 3 * % 9 2
2 9 2 % &
3 9 1 # *
4 7 3 * %

Thanks