Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
gillesda
 
Posts: n/a
Default I need to use a number in one worksheet to match text in another

I need to use a number in a column on the first worksheet to find
corresponding text that goes with that number on another worksheet. This is
all in the same workbook, and it has to be alphebetized afterward.
  #2   Report Post  
Ron de Bruin
 
Posts: n/a
Default

Hi gillesda

Use the Vlookup formula

See Debra's site
http://www.contextures.com/xlFunctions02.html


--
Regards Ron de Bruin
http://www.rondebruin.nl


"gillesda" wrote in message ...
I need to use a number in a column on the first worksheet to find
corresponding text that goes with that number on another worksheet. This is
all in the same workbook, and it has to be alphebetized afterward.



Reply
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
numbering all pages in worksheet Lyn Familant via OfficeKB.com Excel Discussion (Misc queries) 1 February 12th 05 02:26 AM
number of rows on a worksheet Judy Stober Excel Discussion (Misc queries) 1 January 31st 05 11:58 PM
pasting excel data in a powerpoint slide James Excel Discussion (Misc queries) 4 January 28th 05 02:23 PM
Match & Index Phyllis B. Excel Worksheet Functions 2 November 27th 04 03:26 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 08:46 AM.

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

About Us

"It's about Microsoft Excel"