View Single Post
  #5   Report Post  
Alex Delamain
 
Posts: n/a
Default


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...o&userid=11273
View this thread: http://www.excelforum.com/showthread...hreadid=274073