Combining values from different references.

I have a list of "Vendors" & a list of "Customers" with some companies being in both categories. I've made a "Vendors" summary page and a "Customers" summary page, but I'd like to combine the two into a third "Combined" summary page. I've already worked-out (with great help from the forum) how to consolidate the two lists into one, but I still need help in combining the data.

The Vendors have "(V)" at the end of their names and the customers have "(C)".

Maybe my brain is turning to mush, but I can't even figure-out where to start formula-speaking.
Any hint, suggestions, or prods would be greatly appreciated.

I've attached a reduced size file and an image to help visually:
Combine Data.jpg

Sorry, it's under the "Pallets" tab.

I must apologize for this lazy post I did late last night. I should of gone to bed and looked at this with fresh eyes in the morning before asking the forum to look at it.

I'm rested and on it now, and will update the post with at least a legitimate effort before asking the forum for further help.

As always, many thanks go out to the forum moderators, gurus, and all other helpful members for all their input these last couple days. You guys rule!