LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JS JS is offline
external usenet poster
 
Posts: 44
Default Extract a list from master list

Hi,
I have master list (B3:C8) and I'd like to display a list (G3:G4) based on
cell F3. How I could do that?
Thank you.

Column B Column C Column F Column G
Row 3 Fruit Apple Vegetable Cabbage
Row 4 Vegetable Cabbage Broccoli
Row 5 Fruit Grape Spinach
Row 6 Vegetable Broccoli
Row 7 Vegetable Spinach
Row 8 Fruit Orange

 
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
Extract list of units based on error criteria to new list Sheila Excel Worksheet Functions 14 August 9th 07 03:57 AM
Extract list of units based on error criteria to new list Sheila Excel Worksheet Functions 0 August 9th 07 01:50 AM
Master List Kevin Excel Discussion (Misc queries) 6 August 7th 07 05:20 PM
How do I make a master look-up list in Excel? Paco3517 New Users to Excel 6 April 23rd 07 01:54 PM
extract data from a random list & place in another ordered list sean8690 Excel Discussion (Misc queries) 1 January 2nd 07 06:06 PM


All times are GMT +1. The time now is 01:46 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"