If AND VLOOKUP
 

Hi guys, I am looking for a solution that will combine the IF, AND and
VLOOKUP functions to the following problem. In cell A2 I have the word NORTH
and in cell B2 I have the year 2005 ,,,, in cell C2 I want to have a VLOOKUP
that will work depending on the info in cells A2 and B2 ,,,, e.g.
=IF(AND(A2="NORTH",B2="2005",vlookup(A3,range,2,0) ) .........or something
similar , I can't get the formula to work properly ,,,,, any help ?

If AND VLOOKUP
 

=IF(AND(A2="North",B2=2005),VLOOKUP(A3,G3:H6,2,FAL SE))
worked for me.You dont say what the result is when you try.Make sure your
cell conditions are are actually what you are testing for.Note i dont
actually need quotes around 2005.
-
paul

remove nospam for email addy!



"John Moore" wrote:

Hi guys, I am looking for a solution that will combine the IF, AND and
VLOOKUP functions to the following problem. In cell A2 I have the word NORTH
and in cell B2 I have the year 2005 ,,,, in cell C2 I want to have a VLOOKUP
that will work depending on the info in cells A2 and B2 ,,,, e.g.
=IF(AND(A2="NORTH",B2="2005",vlookup(A3,range,2,0) ) .........or something
similar , I can't get the formula to work properly ,,,,, any help ?

If AND VLOOKUP
 

Hi Paul ,,, works fine ,,, thanks for the quick response ,,,

"paul" wrote:

=IF(AND(A2="North",B2=2005),VLOOKUP(A3,G3:H6,2,FAL SE))
worked for me.You dont say what the result is when you try.Make sure your
cell conditions are are actually what you are testing for.Note i dont
actually need quotes around 2005.
-
paul

remove nospam for email addy!



"John Moore" wrote:

Hi guys, I am looking for a solution that will combine the IF, AND and
VLOOKUP functions to the following problem. In cell A2 I have the word NORTH
and in cell B2 I have the year 2005 ,,,, in cell C2 I want to have a VLOOKUP
that will work depending on the info in cells A2 and B2 ,,,, e.g.
=IF(AND(A2="NORTH",B2="2005",vlookup(A3,range,2,0) ) .........or something
similar , I can't get the formula to work properly ,,,,, any help ?

If AND VLOOKUP
 

Hi again ,,,, Could this be extended to cover multiple scenarios ,,,,, e.g.
if A2 was South and B2 was 2006 ,,,,and could it also incorporate the
IFISERROR function to return 0 in the event of an error ?

"John Moore" wrote:

Hi Paul ,,, works fine ,,, thanks for the quick response ,,,

"paul" wrote:

=IF(AND(A2="North",B2=2005),VLOOKUP(A3,G3:H6,2,FAL SE))
worked for me.You dont say what the result is when you try.Make sure your
cell conditions are are actually what you are testing for.Note i dont
actually need quotes around 2005.
-
paul

remove nospam for email addy!



"John Moore" wrote:

Hi guys, I am looking for a solution that will combine the IF, AND and
VLOOKUP functions to the following problem. In cell A2 I have the word NORTH
and in cell B2 I have the year 2005 ,,,, in cell C2 I want to have a VLOOKUP
that will work depending on the info in cells A2 and B2 ,,,, e.g.
=IF(AND(A2="NORTH",B2="2005",vlookup(A3,range,2,0) ) .........or something
similar , I can't get the formula to work properly ,,,,, any help ?

If AND VLOOKUP
 

within the limitations of 7 or 9 nested ifs yes.....
if(and(a2="north",b2=2005)vlookup(a3,range,etc),vl ookup(.....
this would result in another lookup if anything other than north and 2005 in
a2 and b2
you could keep going with the nested ifs and you could use iserror to keep
it tidy.
if(iserror(vlookup.....if(and(a2="north",b2=2005)v lookup(a3,range,etc),if(and(a2="south",b2=2006), vlookup(a4,range.....)))

--
paul

remove nospam for email addy!



"John Moore" wrote:

Hi again ,,,, Could this be extended to cover multiple scenarios ,,,,, e.g.
if A2 was South and B2 was 2006 ,,,,and could it also incorporate the
IFISERROR function to return 0 in the event of an error ?

"John Moore" wrote:

Hi Paul ,,, works fine ,,, thanks for the quick response ,,,

"paul" wrote:

=IF(AND(A2="North",B2=2005),VLOOKUP(A3,G3:H6,2,FAL SE))
worked for me.You dont say what the result is when you try.Make sure your
cell conditions are are actually what you are testing for.Note i dont
actually need quotes around 2005.
-
paul

remove nospam for email addy!



"John Moore" wrote:

Hi guys, I am looking for a solution that will combine the IF, AND and
VLOOKUP functions to the following problem. In cell A2 I have the word NORTH
and in cell B2 I have the year 2005 ,,,, in cell C2 I want to have a VLOOKUP
that will work depending on the info in cells A2 and B2 ,,,, e.g.
=IF(AND(A2="NORTH",B2="2005",vlookup(A3,range,2,0) ) .........or something
similar , I can't get the formula to work properly ,,,,, any help ?