no htis is not what i want... i am too confused.
my simple requirement is i want to do a vlookup with 2
column values rather than with one value.
pls suggest if its feasible.
thanks again
alex
-----Original Message-----
From your last post I am guessing that column D contains
your lookup
formula which has been array entered and copied down the
list of data.
If this is the case then it will give "Water" as the
result every time
because it performs the same calculation on the whole
data list every
time. The idea behind using an array formula is that a
single cell can
check a whole list of data without having to be copied
down all the
rows
If you intend to copy the formula down the data in
another column then
the formula could be
=IF(AND(A2="Brian",B2="blue"),+C2,"")
--
Alex Delamain
----------------------------------------------------------
--------------
Alex Delamain's Profile:
http://www.excelforum.com/member.php?
action=getinfo&userid=11273
View this thread:
http://www.excelforum.com/showthread...hreadid=274073
.