• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

match, vlookup, index help

M

melinda

New Member
Hello, and thank you in advance for your assistance!

I have a spread sheet with 3 sub sections, 1st is the main data (A3:G48), 2nd I3:N39) and the NON match section (P3:U??)

Goal is to identify the differences in section 1 (A-G) & 2 (I-N) and spit out in 3 (P-U).

Cusip is KING on section 1. In P3 look up cusip A3 and find in I3:39-if match found place cusip place in p3. Also for each cusip found match b=j, c=k, d=l, e or f=m and g=n. If there is a difference, color and populate with b,c,d,e/f & g.

Question: how to write the formulas, and also how can I identify cusips located in A that is not in I, or is in I and not in A.

thank you!
 

Attachments

Have a look at this and see if it suits .... sorry got started and had to finish quick as something came up but think it has everything you need ... just needs a bit of tidying up
 

Attachments

Somendra Misra said:
Hi,

See this file, formula in range P3:V38. Write back if you need something else.

Regards,
Click to expand...
THANK YOU, YOU ALL ARE AMAZING! But I do have a questions in your column X, what is that for?

If I would expand both the data in columns A-G and I-N, would If I would copy the formulas in P-V-Match data, and Y-AE down it would incorporate the new rows?
Thanks!
 
melinda said:
THANK YOU, YOU ALL ARE AMAZING! But I do have a questions in your column X, what is that for?

If I would expand both the data in columns A-G and I-N, would If I would copy the formulas in P-V-Match data, and Y-AE down it would incorporate the new rows?
Thanks!
Click to expand...


YOUR COLUMN X IS HARD CODED, NO FORMULA TO COPY DOWN, WHAT IS THE FORMULA FOR THIS COLUMN (THIS IS WHAT DRIVES COLUMNS Y:AE TO POPULATE?
 
Melinda ... when i tried your problem one of your criteria was how to identify cusips located in A that is not in I, or is in I and not in A.
this is what this was for .... Colum y contains cusips that are in A but not in I .... then i realised i could do the same job if i used Conditional formatting by selecting colums A and I and highlighting Duplicates. As you can see the cuisps in A and I that are the same are highlighted ... the ones not highlighted in A are ones that dont appear in I and the ones not highlighted in I are the ones that dont appear in A
hope this helps you understand ....
if you look at the sheet above that i uploaded with my original post .... you will see in E46 how i got the numbers that appear in X .... i just copied them from E46 colum and pasted them as valuse there and then used them as row numbers in the formula in Y
 
You must log in or register to reply here.
Back
Top