sort, move and vlookup, I'm really not sure

[mrxwanttobe]

Please help if you can

So in column "A1" I have a part number like 12345 and in "A2" I have a number 12345C. It goes on like this for 10,000 lines. Column "B" has prices. I need the prices on the same line. I could do this using Vlookup if I could move just he parts with "C" at the end to another sheet or just the parts without the "C" to another sheet.

Please help if this can be done

 

[C Moore]

Maybe add a third column that looks for C in the number? =isnumber(find("c",A2)) sort by true/false and cut to another sheet.