If and Vlookup
 

I am trying to get a vllook up to be conditional if a certain criteria is
met. I have tried =IF('Raw Data'!B$2=AB,(VLOOKUP($A4,'Raw
Data'!$A:$A,7,FALSE),0)

Raw Data is the sheet that I need information from. I need the formula to
look in colum b and determine if the value is AB or CF. If it matches AB I
need it to do a vlookup based on the customer number in column A of that row
and return the value in colum 7 . I need to be able to drag this formula
vertically and horizontally. Please help. Thanks

If and Vlookup
 

If you're looking for the text "AB", you need to put it in quotes. You also
have mismatched parentheses. Try:
=IF('Raw Data'!B$2="AB",VLOOKUP($A4,'Raw Data'!$A:$A,7,FALSE),0)

Regards,
Fred

"Confused in AZ" <Confused in wrote in message
...
I am trying to get a vllook up to be conditional if a certain criteria is
met. I have tried =IF('Raw Data'!B$2=AB,(VLOOKUP($A4,'Raw
Data'!$A:$A,7,FALSE),0)

Raw Data is the sheet that I need information from. I need the formula to
look in colum b and determine if the value is AB or CF. If it matches AB
I
need it to do a vlookup based on the customer number in column A of that
row
and return the value in colum 7 . I need to be able to drag this formula
vertically and horizontally. Please help. Thanks

If and Vlookup
 

To add to Fred's suggestion...

You want the return to be from the 7th column of the lookup_table but you
only reference A:A as the table. Perhaps A100:G100 as an example would
work.

HTH
Regards,
Howard

"Confused in AZ" <Confused in wrote in message
...
I am trying to get a vllook up to be conditional if a certain criteria is
met. I have tried =IF('Raw Data'!B$2=AB,(VLOOKUP($A4,'Raw
Data'!$A:$A,7,FALSE),0)

Raw Data is the sheet that I need information from. I need the formula to
look in colum b and determine if the value is AB or CF. If it matches AB
I
need it to do a vlookup based on the customer number in column A of that
row
and return the value in colum 7 . I need to be able to drag this formula
vertically and horizontally. Please help. Thanks

If and Vlookup
 

Good catch, Howard. So the formula would look like
=IF('Raw Data'!B$2="AB",VLOOKUP($A4,'Raw Data'!$A:$G,7,FALSE),0)

Regards,
Fred



"L. Howard Kittle" wrote in message
...
To add to Fred's suggestion...

You want the return to be from the 7th column of the lookup_table but you
only reference A:A as the table. Perhaps A100:G100 as an example would
work.

HTH
Regards,
Howard

"Confused in AZ" <Confused in wrote in
message ...
I am trying to get a vllook up to be conditional if a certain criteria is
met. I have tried =IF('Raw Data'!B$2=AB,(VLOOKUP($A4,'Raw
Data'!$A:$A,7,FALSE),0)

Raw Data is the sheet that I need information from. I need the formula
to
look in colum b and determine if the value is AB or CF. If it matches AB
I
need it to do a vlookup based on the customer number in column A of that
row
and return the value in colum 7 . I need to be able to drag this formula
vertically and horizontally. Please help. Thanks