If and Vlookup

  • Thread starter Thread starter Confused in AZ
  • Start date Start date
C

Confused in AZ

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 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
 
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
 
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
 
Back
Top