Completely Lost, Please Look

[Weetnie]

I have an excel spreadsheet with hundreds of rows and columns regarding one company and their services.

What I want to do is, for example,

I look up CC's product key:12345 and it shows me that it's done business with PC under product key 54321.

I then look up PC's product key 54321 to see if it's done business with CC under product key 12345.

Basically I want to find out if CC has done business with PC, I want to double check if PC has or has not done business with CC so it does not over lap.

If it's too confusing I'll try to explain better. Thanks for all the help.

 

[VBACO]

Can you post a sample of the sheet and desired result please?

 

[Weetnie]

Sure

-- removed inline image ---

A B C D
Description 5116143 Description 5116144
Description 5116144 Description 5116143


The highlighted blue is the intended result.

First, I'm checking the numbers in column B, if I select 5116143, it will show me that that number corresponds to 5116144 in column D. Now the hard part is, I have to go back to column B and check 5116144 to see if it matches 5116143 in column D.

Hope this helps

 

[Weetnie]

Sure


A B C D
Description 5116143 Description 5116144
Description 5116144 Description 5116143


The highlighted blue is the intended result.

First, I'm checking the numbers in column B, if I select 5116143, it will show me that that number corresponds to 5116144 in column D. Now the hard part is, I have to go back to column B and check 5116144 to see if it matches 5116143 in column D.

Hope this helps