Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Bobgolfs56
 
Posts: n/a
Default How do I find data from a list (or table) and insert it in a row?

I used to use a spreadsheet program (2 years ago) that allowed me to lookup
an item and insert it into the worksheet. I know the program was at least a
year old at that time (2002). How do I create a list, reference it , and
then insert an item into a row of my choice?

Example: Make of item, item description, and cost.

Does the data go on one worksheet and then get referenced and inserted into
the list of another worksheet? If so, how? I can't seem to get any answers
by reading books on the subject. I no longer have access to the old workbook
from which to study.
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Maybe that old workbook used =vlookup() or =index(match())

You could look at Debra Dalgleish's site:
http://www.contextures.com/xlFunctions02.html
and
http://www.contextures.com/xlFunctions03.html

to see if that rings a bell.

Bobgolfs56 wrote:

I used to use a spreadsheet program (2 years ago) that allowed me to lookup
an item and insert it into the worksheet. I know the program was at least a
year old at that time (2002). How do I create a list, reference it , and
then insert an item into a row of my choice?

Example: Make of item, item description, and cost.

Does the data go on one worksheet and then get referenced and inserted into
the list of another worksheet? If so, how? I can't seem to get any answers
by reading books on the subject. I no longer have access to the old workbook
from which to study.


--

Dave Peterson
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
Challenging Charting C TO Charts and Charting in Excel 0 January 17th 05 07:57 PM
insert a table in excel Phil1723 Excel Discussion (Misc queries) 3 January 12th 05 03:08 PM
Insert column in Pivot Table NewExcel2003User Excel Worksheet Functions 1 November 24th 04 12:20 PM
matching data formula? Todd Excel Worksheet Functions 1 November 16th 04 09:44 PM
Grouping data within intervals Cartesio Excel Worksheet Functions 0 November 2nd 04 02:45 PM


All times are GMT +1. The time now is 04:20 PM.

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"