|
VLOOKUP with 2 conditions
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 |
VLOOKUP with 2 conditions
=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 |
VLOOKUP with 2 conditions
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 |
VLOOKUP with 2 conditions
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 |
VLOOKUP with 2 conditions
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 |
VLOOKUP with 2 conditions
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 |
| All times are GMT +1. The time now is 11:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com