hi all
I want to find the vehicle number that is in column "B". But before the vehicle number in column "B" is checked first if there is a number in column "C", if it is in column "C", then display the vehicle number (from column B). If there is no column "C" then make it "0" or empty. please kindly help
thank you...
regard
dolphino
this is sample from my thread.
attaached.
I dont understand what you are doing here
you say....
All cells in col C contain data, but your results show 3 0's??if there is a number in column "C", if it is in column "C", then display the vehicle number (from column B). If there is no column "C" then make it "0"
Also, the contents of C4 (which you show as 0) can be found in B8?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Maybe try
E4
=IF(C4>0,SUBSTITUTE(MID(B4,SEARCH("(? * *)",B4)+1,10),")",),0)
hi FDibbins
i'm sorry if make u confuse,
i mean. i first check the vehicle number if it is in column "c." if there is in column "c", then vehicle number there is in column "b" is showed. example cell "b5", column "b" is the vehicle number b 1655 paa, if check to column "c" vehicle number is there. then then the number is presented as a result (cell e5). please kindly help.
thankyou
dolphino
hi Bo_Ry
thank you before from your help. but for cells E4, E7, E11 should return "0" / zero because the vehicle numbers in cells b4, b7, b11 are not in column C .
regard
dolphino
Try
=IFERROR(VLOOKUP(SUBSTITUTE(MID(B4,SEARCH("(? * *)",B4)+1,10),")",),$C$4:$C$11,1,0),0)
=IFNA(VLOOKUP(SUBSTITUTE(MID(B4,SEARCH("(? * *)",B4)+1,10),")",),$C$4:$C$11,1,0),0)
HI Bo_Ry
That right, your formulla is working correctly. im verry happy
thank you very much.
regard
dolphino
Hi all,
still from my thread,
It turns out that in my data there is a condition where the vehicle number has no opening and closing brackets. If conditions like this, what additional formulas do I need to add to CELL E12, E13, E14 ?
sample new attached... kindly help for this.
thank you
regard
dolphino
try
=IFERROR(LOOKUP(0,-FIND($C$4:$C$14,B4),$C$4:$C$14),0)
Try to search column C in B4, if found, return relative V-id:
In E4:
Please Login or Register to view this content.
Quang PT
Hi Bo_Ry
okay, that true. you on of the best.
thank you .
regard
dolphino
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks