ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to automatically populate cells using lookup tables (https://www.excelbanter.com/excel-discussion-misc-queries/51677-how-automatically-populate-cells-using-lookup-tables.html)

felipe

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.

Anne Troy

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.





All times are GMT +1. The time now is 02:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com