Common Entries Between Lists

**RDK22** · 05-05-2007, 08:29 AM

I have a spreadsheet with three columns of numbers. The 2nd and 3rd columns need to stay connected. How can I match the numbers in column one with the numbers in column two to show only the ones that match while still keeping columns two and three connected?

**starguy** · 05-05-2007, 09:36 AM

Originally Posted by RDK22

I have a spreadsheet with three columns of numbers. The 2nd and 3rd columns need to stay connected. How can I match the numbers in column one with the numbers in column two to show only the ones that match while still keeping columns two and three connected?

Hi
You are not clear when you say you want to keep the columns connected.
however see the following thread, it may help you.

http://www.excelforum.com/showthread.php?t=598888

**olasa** · 05-06-2007, 12:37 PM

I suppose you need the =VLOOKUP(...) function.
You could watch this video, but I would fast forward to 5:20. That is where you see how the formula works.

Hope it helped.
//Ola

Common Entries Between Lists

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Common Entries Between Lists

VLOOKUP video

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions