LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Matching and combining information on two separate worksheets

Is there a way to do the following?

One worksheet has the following information

02 - Sandee
03 - Scott
156 - Kali
300 - Tom

The other worksheet has

02
156
300
02
03


What I need to do is if the number from the first worksheet is in a column
in the second worksheet. I need to put the corresponding name with the
number (no matter how many times the number shows up).

Can someone help me with this?

Thanks
--
Sandee
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Matching names and combining worksheets Irma A Excel Discussion (Misc queries) 5 April 2nd 09 08:22 PM
matching data on two separate worksheets jodi Excel Discussion (Misc queries) 1 September 17th 07 03:16 AM
Combining Information from Multipole Worksheets into One... Raspberry Excel Discussion (Misc queries) 2 December 9th 06 07:19 PM
Combining data from multiple worksheets and separate spreadsheets kfletchb Excel Discussion (Misc queries) 1 August 10th 06 07:53 PM
relative information in two separate worksheets? Hanabele Excel Worksheet Functions 1 May 6th 06 09:55 PM


All times are GMT +1. The time now is 12:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"