Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
felipe
 
Posts: n/a
Default how to automatically populate cells using lookup tables

Have researched Help Index to exhaustion. Want to enter value in one cell
which will automatically populate another cell from a lookup table merely as
a labor saving and validation device. This is called "grouping" in database
softwares, but no term I have so far tried summons germane articles from
Online Help.
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default how to automatically populate cells using lookup tables

I don't see how it's called grouping, but... try this explanation:
http://www.officearticles.com/excel/...soft_excel.htm
or this tutorial:
http://www.officearticles.com/tutori...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"felipe" wrote in message
...
Have researched Help Index to exhaustion. Want to enter value in one cell
which will automatically populate another cell from a lookup table merely
as
a labor saving and validation device. This is called "grouping" in
database
softwares, but no term I have so far tried summons germane articles from
Online Help.



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
How to select cells (located in a column) for formulas in a row automatically? Dmitry Kopnichev Excel Worksheet Functions 3 October 11th 05 07:39 PM
return a range of cells from a vertical lookup vickyb_au Excel Worksheet Functions 2 October 11th 05 11:15 AM
Populate multiple cells using the same reference nick Excel Worksheet Functions 0 October 3rd 05 03:33 PM
Excel 97 - Selecting multiple cells from 2 different Pivot Tables jjones_HAB Excel Discussion (Misc queries) 0 March 1st 05 12:01 PM
Protected cells -automatically format to a different color Fred Evans Excel Discussion (Misc queries) 9 December 3rd 04 12:59 PM


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