LinkBack URL
About LinkBacks
Hi, I can't figure out how to make this work. I want the value of C3 to be L. How can I accomplish this?
Hi, I can't figure out how to make this work. I want the value of C3 to be L. How can I accomplish this?
Not clear, could you please add the expected output so that it will be easier to understand your requirement.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Let me know if this helps, thanks.Originally Posted by :) Sixthsense :)
actually it doesnt. how do you arrive at the values on column C? please walk us through the logic?
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
What I want to accomplish is check to see if the value of B2 is the same as A2&"-"&C6 and if it is return the value at C2
Try this formula in C3 cell
Formula:
=VLOOKUP(SUBSTITUTE(LEFT($B3,FIND("^",SUBSTITUTE($B3,"-","^",3))-1)," ",""),Sheet2!$A:$M,MATCH(IFERROR(--MID($B3,FIND("^",SUBSTITUTE($B3,"-","^",3))+1,255),$B3),Sheet2!$A$1:$M$1,0),0)
But it is a half solution only because of your irregular data structure.
Refer the attached excel to know for what reason the above formula is getting failed.
That worked when I standardized the colors. Thank you. I am a excel newb, do you mind explaining the formula to me?Try this formula in C3 cell
Formula:=VLOOKUP(SUBSTITUTE(LEFT($B3,FIND("^",SUBSTITUTE($B3,"-","^",3))-1)," ",""),Sheet2!$A:$M,MATCH(IFERROR(--MID($B3,FIND("^",SUBSTITUTE($B3,"-","^",3))+1,255),$B3),Sheet2!$A$1:$M$1,0),0)
But it is a half solution only because of your irregular data structure.
Refer the attached excel to know for what reason the above formula is getting failed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks