The thread has aged off (for me).
It sounds like you're using some sort of =if() function without the final
condition:
=if(something,trueportion,falseportion)
If you don't put something in that false portion, you'll see False.
Pedro AM wrote:
Dave
The formula that you told me here has worked out quite well so far for me
until now. I get a "FALSE" return and I have no idea as to why.
Is there anything you can think of?
it has exactly the same setting as all the other cells (around 50 lines over
5 columns with same formula).
thanks
"Dave Peterson" wrote:
Select the range that contains the formula
Format|cells|Alignment tab
Make sure Merge is not checked/or is clear.
Pedro AM wrote:
Hi Peo
I am trying to apply the formula that you showed here but it does not work
on mine.
The message, by the way, is that I cant use array formulas in merged cells
but I have no merged cells at all.do you have any ideas of why?
"Peo Sjoblom" wrote:
=INDEX(C1:C10,MATCH(1,(A1:A10="x")*(B1:B10="y"),0) )
entered with ctrl + shift & enter
where x and y are the 2 criteria for A and B
--
Regards,
Peo Sjoblom
Portland, Oregon
"RSantos" wrote in
message ...
HI
I´ve seen many solutions in the forum to use 2 or more conditions,
however either tehy don´t aply to my problem or I can´t understand
them. I need to get, for example, the value of col C based on the
values of col A and B.
Can anybody help?
Is there a way to do it with VBA?
Thaks
--
RSantos
------------------------------------------------------------------------
RSantos's Profile:
http://www.excelforum.com/member.php...o&userid=31240
View this thread: http://www.excelforum.com/showthread...hreadid=509663
--
Dave Peterson
--
Dave Peterson