Assuming value required is in column C and columns A & B contain your "search
parameters" then:

=INDEX(C1:C100,MATCH(1,(A1:A100=322654)*(B1:B100=0 15"),0),1)

Enter with Control+Shift+Enter (as an array formula). Curly brackets {} will
appear around the formula if it is entered correctly.

HTH

"ramalana" wrote:


Hello

I am trying to return a value based on a multiple VLOOKUP

i.e. spreadsheet contains multiple lines for given value, say 322654,
and also multiple lines for second lookup value of 015, although there
will only be one 015 for 322654. I would like to return a related cell
that fulfills both of these conditions.

Alternatively perhaps I could use a VLOOKUP with an IF function built
in, any ideas please let me know.

Many thanks


--
ramalana
------------------------------------------------------------------------
ramalana's Profile: http://www.excelforum.com/member.php...o&userid=36949
View this thread: http://www.excelforum.com/showthread...hreadid=566586