LinkBack URL
About LinkBacks
In the attachemtn I need to bring the QBS to-brk number to the according final collum contra brk name.
How do I do this?
example:
The first number is 3101 for Morgan stanley OCC so in the final collumn MORGAN STANLEY OCC number needs to be 3101
In the attachemtn I need to bring the QBS to-brk number to the according final collum contra brk name.
How do I do this?
example:
The first number is 3101 for Morgan stanley OCC so in the final collumn MORGAN STANLEY OCC number needs to be 3101
Hi, welcome to the forum
Not sure I completely understand your question, but if you want to pull the value from column A that relates to column F, then try this, copied down...
=INDEX($A$3:$A$22972,MATCH(F3,$B$3:$B$22972,0))
I would however, suggest you remove all those duplicates.
In A-B you have 22970 entries, this can be reduced to 288 by removing the duplicates
Likewise in E-F you have 20915 entries, this can be reduced to 260 by removing the duplicates
(also you have additional duplicates caused by typos..."GOLDMAN, SACHS & CO." & "GOLDMAN SACHS & CO." as well as a ton of trailing spaces in your data
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
Hi :D
I am sorry I wasn't elaborate, so what I need is the QBS TO-BRKR number is the accurate number that needs to go on the FINAL collumns.
So the first one for example is Morgan Stanley OCC 3101 so I need in the final collumn for Morgan stanley OCC to be 3101 as well.
Where do you suggest for me to input the formula you stated?
Thank you so much! This forum is awesome!
I think thats what I gave you. Put that in G3 and copy down.
If thats not what you wanted, please tell me which column to use as teh base, and which column you want the answer in?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks