| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup from another tab
Hi, I was wondeirng if anyone can help me. Is it possible to have a vlookup
be a part of an IF statement? In my Column L I need it to check in another tab of my workbook to see if a division is obsolete and if it is then mark it as Obsolete Division Obsolete Status A Obsolete B Active C Obsolete Any help is super appreciated!!!! Thank you! My formula needs to do something like if in the lookup on another tab looking up Division it could look it up and then if it's obsolete mark it that way? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup from another tab
Try this:
A1 = lookup value =IF(VLOOKUP(A1,Sheet2!A1:B10,2,0)="Obsolete","Obso lete","") -- Biff Microsoft Excel MVP "H" wrote in message ... Hi, I was wondeirng if anyone can help me. Is it possible to have a vlookup be a part of an IF statement? In my Column L I need it to check in another tab of my workbook to see if a division is obsolete and if it is then mark it as Obsolete Division Obsolete Status A Obsolete B Active C Obsolete Any help is super appreciated!!!! Thank you! My formula needs to do something like if in the lookup on another tab looking up Division it could look it up and then if it's obsolete mark it that way? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup from another tab
Somthing like this..If a value is found it returns or else mark it as
"Obsolete" =IF(ISNA(VLOOKUP(A1,Sheet2!A1:B10,2,0)),"Obsolete" ,VLOOKUP(A1,Sheet2!A1:B10,2,0)) If this post helps click Yes --------------- Jacob Skaria "T. Valko" wrote: Try this: A1 = lookup value =IF(VLOOKUP(A1,Sheet2!A1:B10,2,0)="Obsolete","Obso lete","") -- Biff Microsoft Excel MVP "H" wrote in message ... Hi, I was wondeirng if anyone can help me. Is it possible to have a vlookup be a part of an IF statement? In my Column L I need it to check in another tab of my workbook to see if a division is obsolete and if it is then mark it as Obsolete Division Obsolete Status A Obsolete B Active C Obsolete Any help is super appreciated!!!! Thank you! My formula needs to do something like if in the lookup on another tab looking up Division it could look it up and then if it's obsolete mark it that way? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
| Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| 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 | |||
Linear Mode
