Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |