| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup with 3 or more conditions | Excel Worksheet Functions | |||
| How do you do a VLookup with two conditions? | Excel Worksheet Functions | |||
| Vlookup using 2 conditions | Excel Discussion (Misc queries) | |||
| How:iserror vlookup & count no. times value shows with conditions | Excel Worksheet Functions | |||
| Vlookup with multiple conditions | Excel Worksheet Functions | |||
Linear Mode
