LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Lookup value, display multiple values in new worksheet

I want to look up a value from a column in one worksheet and display the
value from the next column, but in another worksheet. I can do if it is in
the same worksheet, but the formula doesn't work if I use cell ranges from
another sheet.

ex:
Name Type
Bob A
Joe B
Cindy A

Now in a column on a new worksheet I want to pull all names that fall under
type A...
 
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
Lookup values and display them damanwitdaplan Excel Discussion (Misc queries) 4 January 5th 09 03:04 AM
Lookup letters and display highest values in a pivot table notso Excel Discussion (Misc queries) 3 January 24th 07 04:10 AM
Lookup and Display Using Multiple Criteria GB Excel Worksheet Functions 4 October 3rd 06 11:40 PM
Lookup baseball scores in 1 worksheet and have them display in ano Oceanverd Excel Worksheet Functions 3 May 1st 05 04:44 AM
Lookup values in a column and display them in order with no gaps Snaggle22 Excel Worksheet Functions 1 April 12th 05 11:36 PM


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

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"