Hi

The solution depends on your data. When the return value is numeric and
combined conditions always determine a single row or none, you can use
SUMPRODUCT function, like
=SUMPRODUCT(--(Sheet1!A1:$A$1000=322654),--Sheet1!$B$1:$B$1000="015",Sheet1!$C$1:$C$1000)
(when there are several rows matching all conditions, the formula returns
the sum of according values - in my example in column C)

When the return value is string, you have to use array formulas or helper
columns, like explained in previous answers.


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"ramalana" wrote in
message ...

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