Matching columns where one value is the same?

Zeldaa

New Member
Joined
Mar 8, 2011
Messages
9
Hi

I was hoping someone could offer me a little help please.

Column A CustomerID
Column B Customer
Column E Customer
Column F Notes

My customers are unique, column A and B only have about 250 customers, but Columns E and F have like over 15,000 customers.

What I'm trying to do is show customer and notes in columns c and d (from columns E and F) where the customer in column B is the same as column e.

as mentioned before my customer are unique match the same.

If you require any more information then please let me know.
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
Hopefully i've understood your problem correctly?

C2:
Code:
=VLOOKUP(B2,E:F,1,FALSE)

D2:
Code:
=VLOOKUP(B2,E:F,2,FALSE)
 
Upvote 0
Hi

I was hoping someone could offer me a little help please.

Column A CustomerID
Column B Customer
Column E Customer
Column F Notes

My customers are unique, column A and B only have about 250 customers, but Columns E and F have like over 15,000 customers.

What I'm trying to do is show customer and notes in columns c and d (from columns E and F) where the customer in column B is the same as column e.

as mentioned before my customer are unique match the same.

If you require any more information then please let me know.
If the customer in column B can also be found in column E then why would you want to also list the same customer again in column C?

Seems a bit redundant to me?
 
Upvote 0
Zeldaa,

Duplicate post here:
http://www.ozgrid.com/forum/showthread.php?t=151964


What version of Excel are you using?

You will generally get much more help (and faster) in this forum if you can post your small samples directly in the forum.

Please attach screenshots of your workbook or a sample workbook that accurately portrays your current workbook on one sheet, and what it should look like 'After' on another sheet.

This makes it much easier to see exactly what you want to do, as well as shows us whether there is a consistent number of rows between tables and such.

Here are three possible ways to post small (copyable) screen shots directly in your post:

Please post a screenshot of your sheet(s), what you have and what you expect to achieve, with Excel Jeanie HTML 4 (contains graphic instructions).
http://www.excel-jeanie-html.de/html/hlp_schnell_en.php

or
RichardSchollar’s beta HTML Maker -...his signature block at the bottom of his post

or
Borders-Copy-Paste



If you are not able to give us screenshots:

To get the most precise answer, it is best to upload/attach a sample workbook (sensitive data scrubbed/removed) that contains an example of your raw data on one worksheet, and on another worksheet your desired results.

The structure and data types of the sample workbook must exactly duplicate the real workbook. Include a clear and explicit explanation of your requirements.

You can upload your workbook to www.box.net and provide us with a link to your workbook.
 
Upvote 0
That did the trick many thanks, i had to do it this way because i wanted to compare the data.

many thanks again.
 
Upvote 0

Forum statistics

Threads
1,224,587
Messages
6,179,738
Members
452,940
Latest member
Lawrenceiow

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top