If and Vlookup

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
 
F

Fred Smith

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
 
L

L. Howard Kittle

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
 
F

Fred Smith

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top