software

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: www.excelforum.com/member.php...oamp;userid=31240
View this thread: www.excelforum.com/showthread...hreadid=509663=INDEX(C1:C10,MATCH(1,(A1:A10=quot;xquot;)*(B1:B10=quot;yquot;),0) )

entered with ctrl shift amp; enter

where x and y are the 2 criteria for A and B

--
Regards,

Peo Sjoblom

Portland, Oregon

quot;RSantosquot; gt; wrote in
message ...
gt;
gt; HI
gt;
gt; Iｴve seen many solutions in the forum to use 2 or more conditions,
gt; however either tehy donｴt aply to my problem or I canｴt understand
gt; them. I need to get, for example, the value of col C based on the
gt; values of col A and B.
gt;
gt; Can anybody help?
gt;
gt; Is there a way to do it with VBA?
gt;
gt; Thaks
gt;
gt;
gt; --
gt; RSantos
gt; ------------------------------------------------------------------------
gt; RSantos's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31240
gt; View this thread: www.excelforum.com/showthread...hreadid=509663
gt;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?

quot;Peo Sjoblomquot; wrote:

gt; =INDEX(C1:C10,MATCH(1,(A1:A10=quot;xquot;)*(B1:B10=quot;yquot;),0) )
gt;
gt; entered with ctrl shift amp; enter
gt;
gt; where x and y are the 2 criteria for A and B
gt;
gt; --
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Portland, Oregon
gt;
gt;
gt;
gt;
gt; quot;RSantosquot; gt; wrote in
gt; message ...
gt; gt;
gt; gt; HI
gt; gt;
gt; gt; Iﾂｴve seen many solutions in the forum to use 2 or more conditions,
gt; gt; however either tehy donﾂｴt aply to my problem or I canﾂｴt understand
gt; gt; them. I need to get, for example, the value of col C based on the
gt; gt; values of col A and B.
gt; gt;
gt; gt; Can anybody help?
gt; gt;
gt; gt; Is there a way to do it with VBA?
gt; gt;
gt; gt; Thaks
gt; gt;
gt; gt;
gt; gt; --
gt; gt; RSantos
gt; gt; ------------------------------------------------------------------------
gt; gt; RSantos's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=31240
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=509663
gt; gt;
gt;
gt;

Select the range that contains the formula
Format|cells|Alignment tab
Make sure Merge is not checked/or is clear.

Pedro AM wrote:
gt;
gt; Hi Peo
gt;
gt; I am trying to apply the formula that you showed here but it does not work
gt; on mine.
gt; The message, by the way, is that I cant use array formulas in merged cells
gt; but I have no merged cells at all.do you have any ideas of why?
gt;
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt; gt; =INDEX(C1:C10,MATCH(1,(A1:A10=quot;xquot;)*(B1:B10=quot;yquot;),0) )
gt; gt;
gt; gt; entered with ctrl shift amp; enter
gt; gt;
gt; gt; where x and y are the 2 criteria for A and B
gt; gt;
gt; gt; --
gt; gt; Regards,
gt; gt;
gt; gt; Peo Sjoblom
gt; gt;
gt; gt; Portland, Oregon
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;RSantosquot; gt; wrote in
gt; gt; message ...
gt; gt; gt;
gt; gt; gt; HI
gt; gt; gt;
gt; gt; gt; Iﾂｴve seen many solutions in the forum to use 2 or more conditions,
gt; gt; gt; however either tehy donﾂｴt aply to my problem or I canﾂｴt understand
gt; gt; gt; them. I need to get, for example, the value of col C based on the
gt; gt; gt; values of col A and B.
gt; gt; gt;
gt; gt; gt; Can anybody help?
gt; gt; gt;
gt; gt; gt; Is there a way to do it with VBA?
gt; gt; gt;
gt; gt; gt; Thaks
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; RSantos
gt; gt; gt; ------------------------------------------------------------------------
gt; gt; gt; RSantos's Profile:
gt; gt; gt; www.excelforum.com/member.php...oamp;userid=31240
gt; gt; gt; View this thread: www.excelforum.com/showthread...hreadid=509663
gt; gt; gt;
gt; gt;
gt; gt;

--

Dave Peterson

Dave

The formula that you told me here has worked out quite well so far for me
until now. I get a quot;FALSEquot; 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

quot;Dave Petersonquot; wrote:

gt; Select the range that contains the formula
gt; Format|cells|Alignment tab
gt; Make sure Merge is not checked/or is clear.
gt;
gt; Pedro AM wrote:
gt; gt;
gt; gt; Hi Peo
gt; gt;
gt; gt; I am trying to apply the formula that you showed here but it does not work
gt; gt; on mine.
gt; gt; The message, by the way, is that I cant use array formulas in merged cells
gt; gt; but I have no merged cells at all.do you have any ideas of why?
gt; gt;
gt; gt; quot;Peo Sjoblomquot; wrote:
gt; gt;
gt; gt; gt; =INDEX(C1:C10,MATCH(1,(A1:A10=quot;xquot;)*(B1:B10=quot;yquot;),0) )
gt; gt; gt;
gt; gt; gt; entered with ctrl shift amp; enter
gt; gt; gt;
gt; gt; gt; where x and y are the 2 criteria for A and B
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; Regards,
gt; gt; gt;
gt; gt; gt; Peo Sjoblom
gt; gt; gt;
gt; gt; gt; Portland, Oregon
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;RSantosquot; gt; wrote in
gt; gt; gt; message ...
gt; gt; gt; gt;
gt; gt; gt; gt; HI
gt; gt; gt; gt;
gt; gt; gt; gt; Iﾃつｴve seen many solutions in the forum to use 2 or more conditions,
gt; gt; gt; gt; however either tehy donﾃつｴt aply to my problem or I canﾃつｴt understand
gt; gt; gt; gt; them. I need to get, for example, the value of col C based on the
gt; gt; gt; gt; values of col A and B.
gt; gt; gt; gt;
gt; gt; gt; gt; Can anybody help?
gt; gt; gt; gt;
gt; gt; gt; gt; Is there a way to do it with VBA?
gt; gt; gt; gt;
gt; gt; gt; gt; Thaks
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt; RSantos
gt; gt; gt; gt; ------------------------------------------------------------------------
gt; gt; gt; gt; RSantos's Profile:
gt; gt; gt; gt; www.excelforum.com/member.php...oamp;userid=31240
gt; gt; gt; gt; View this thread: www.excelforum.com/showthread...hreadid=509663
gt; gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt;
gt; --
gt;
gt; Dave Peterson
gt;

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:
gt;
gt; Dave
gt;
gt; The formula that you told me here has worked out quite well so far for me
gt; until now. I get a quot;FALSEquot; return and I have no idea as to why.
gt;
gt; Is there anything you can think of?
gt; it has exactly the same setting as all the other cells (around 50 lines over
gt; 5 columns with same formula).
gt;
gt; thanks
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; Select the range that contains the formula
gt; gt; Format|cells|Alignment tab
gt; gt; Make sure Merge is not checked/or is clear.
gt; gt;
gt; gt; Pedro AM wrote:
gt; gt; gt;
gt; gt; gt; Hi Peo
gt; gt; gt;
gt; gt; gt; I am trying to apply the formula that you showed here but it does not work
gt; gt; gt; on mine.
gt; gt; gt; The message, by the way, is that I cant use array formulas in merged cells
gt; gt; gt; but I have no merged cells at all.do you have any ideas of why?
gt; gt; gt;
gt; gt; gt; quot;Peo Sjoblomquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; =INDEX(C1:C10,MATCH(1,(A1:A10=quot;xquot;)*(B1:B10=quot;yquot;),0) )
gt; gt; gt; gt;
gt; gt; gt; gt; entered with ctrl shift amp; enter
gt; gt; gt; gt;
gt; gt; gt; gt; where x and y are the 2 criteria for A and B
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt; Regards,
gt; gt; gt; gt;
gt; gt; gt; gt; Peo Sjoblom
gt; gt; gt; gt;
gt; gt; gt; gt; Portland, Oregon
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; quot;RSantosquot; gt; wrote in
gt; gt; gt; gt; message ...
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; HI
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Iﾃつｴve seen many solutions in the forum to use 2 or more conditions,
gt; gt; gt; gt; gt; however either tehy donﾃつｴt aply to my problem or I canﾃつｴt understand
gt; gt; gt; gt; gt; them. I need to get, for example, the value of col C based on the
gt; gt; gt; gt; gt; values of col A and B.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Can anybody help?
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Is there a way to do it with VBA?
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Thaks
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; --
gt; gt; gt; gt; gt; RSantos
gt; gt; gt; gt; gt; ------------------------------------------------------------------------
gt; gt; gt; gt; gt; RSantos's Profile:
gt; gt; gt; gt; gt; www.excelforum.com/member.php...oamp;userid=31240
gt; gt; gt; gt; gt; View this thread: www.excelforum.com/showthread...hreadid=509663
gt; gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson