Alright so i have two relatively large sheets and from on i just copy and pasted two columns into a new sheet and its looks like this.
[TABLE="class: cms_table, width: 364"]
[tr][td]Primary Key
[/td][td]July 13-Pricing in Local
[/td][/tr][tr][td]0075615-04_Cleveland_BMW
[/td]
[TD="align: right"]0.0058[/TD]
0091182-27_Cleveland_BMW
[/td]
[TD="align: right"]0.4990[/TD]
0091756-12_Cleveland_BMW
[/td]
[TD="align: right"]1.1194[/TD]
0091810_Fountain Inn _E70
[/td]
[TD="align: right"]0.1160[/TD]
0091892-19_Cleveland_BMW
[/td]
[TD="align: right"]0.884[/TD]
[/TABLE]
This is just a snippet from the bigger picture. What i need to do is compare prices from different months but the part numbers from the other sheet may have different rivision levels and maybe spaces an what not but for the most part the first 6-9 numbers should be the same. I want to do a vlookup / if function from a table in the other sheet that will look up the primary key and match it to the primary key in the new sheet (Shown above) and give me the price from column AY.
So essentially i want it to make sure they keys match and return the price from cloumn AY of the other file and put it in the new file (Book 1)
I realize this probably isnt the best explanation so let me know if i can further elaborate on it.