LinkBack URL
About LinkBacks
hi,
How to compare to a string of objects
1. TH0102
2. KJ1403
3. KJ1404
4. TC0910
5. TC0905
Example :
if column data A2 (TC0905) match to any of the objects 1 to 5 , it will return me TRUE.
if(A2=(1,2,3,4,5),TRUE)
Thanks
hi,
How to compare to a string of objects
1. TH0102
2. KJ1403
3. KJ1404
4. TC0910
5. TC0905
Example :
if column data A2 (TC0905) match to any of the objects 1 to 5 , it will return me TRUE.
if(A2=(1,2,3,4,5),TRUE)
Thanks
Last edited by okl; 10-03-2009 at 12:40 PM.
Do you mean ?
=ISNUMBER(MATCH(A2,{"TH0102","KJ1403","KJ1404","TC0910","TC0905"},0))
The inline array can be replaced with a range reference (eg B1:B5) containing values of interest if preferred, not clear.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Thanks, can replace if = TRUE return me "AFTER"
Yes, insert an IF
=IF(ISNUMBER(MATCH(A2,{"TH0102","KJ1403","KJ1404","TC0910","TC0905"},0)),"AFTER","")
im trying to modify to add another checking on column B2 data,
if B2 <> "20" then test the below condition.
=IF(ISNUMBER(MATCH(A2,{"TH0102","KJ1403","KJ1404","TC0910","TC0905"},0)),"AFTER","")
In this case it makes sense to Embed the IFs rather than use AND, ie
=IF(B2<>20,IF(ISNUMBER(MATCH(A2,{"TH0102","KJ1403","KJ1404","TC0910","TC0905"},0)),"AFTER",""),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks