|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
02-19-2008, 03:48 PM
|
|||
|
|||
|
Lookup Discontinued Lines
Hi All
I have a list of lines that i hold stock of. I also have a list of lines that are discontinued How can i get a formula to lookup the discontinued lines and put a Message delete next to the products Hope someone can help Paul 
|
|
#2
02-19-2008, 04:07 PM
|
||||
|
||||
|
Perhaps something like:
e.g. =IF(Isnumber(Match(A1,$X$1:$X$100,0)),"Delete","") copied down where A1 houses a stock you hold and X1:X100 is a list of discontinued lines. IF the stock in A1 appears in X1:X100, then "Delete" appears in cell the formula is in.
__________________
Where there is a will there are many ways. Finding one that works for you is the challenge! Please read the Forum Rules: Rules
|
 |
| Bookmarks |
New topics in F1 Get the most out of Excel Formulas & Functions
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
