I am trying to build a dataset (table) of values compiled from the contents
of many input worksheets.
I would like to know if there is a way to pass the table_array argument to
vlookup based upon a text value stored in a cell (which represents a named

Dear geniuses,
I have price sheets coming from several sources with the same format and
products, but containing difference prices.
I am trying to build a dataset (table) from these sources which I could then

I would like to know if its possible to stop the function in excel that
automatically changes numbers such as 2-28-6 into 2/28/2006.

I'm learning how to use macro and at this point i'm clueless.
I am trying to perform a calculation using different values for one
veriable in my calculation. I have placed all the different values
that i want to use in a separate sheet in the same workbook.

I have an excel file, in version 2002 sp3 file with links to external
workbooks.
When I send this file to a co-worker through Outlook and the co-worker opens
the file and selects to NOT update the links, they receive the #value

Hi there - I copy/paste a few columns from a SQL query in Enterprise
Manager.  The one of the columns has ID's 6-10 digits long, most
simple like 485232189.  However, some begin with a zero.  So, when I
copy/paste this column into excel, it appears like:

Is there any way to lookup the data showing in Column A2:A5000
(Manufacturer) and duplicate this in E2:E500 down but only show it
once i.e. do not allow repetition of the same manufacturer.
At the moment I am adding it manually once a new part number goes in

I am interested in making some graphs to portray 4 different research
designs:  Randomized experiment, regression discontinuity design,
instrumental variable design and matching on observables design.  These are
all economic models.  Basically, all I need is just conceptual ...

Is it possible to protect the template i apply to a doc? i do not want my
styles to change whenever i close and open my documents. can i restrict word
from changing the styles?

I have a column of names, could be 5 different or 4000 different
names.  I want to count the top 10 of this group.  Is there a formula
that will help me do this or do I need to create a macro?

Having a few issues with VLOOKUP, basically if Part Numbers (ColumnD)
contains text and numbers it is okay, hoever, rows that just contain
numbers only or numbers and slashes or dots are showing as #N/A in
ColumnE, have searched on here (http://www.contextures.com/

I gotta vlookup table and on tha other worksheets people enter the info from
dropdown boxes. I need to show the books sold and the average of looks at it
after being chosen to be listed as a summary.
A     B     C

I am trying to build a index for lack of a better name.  I would like
to build a list several of the itmes "cells"  at the beginning of a
spreadsheet .
When these items "cells"  are double clicked, it would take you to the

I have this nice spreadsheet, but somehow additional rows were created at the
bottom, and I can't get rid of them by "deleting", backspace, editing and
deleting the formatting in those rows. Suggestions?

I am new to exel and have no clue as how to enter a formula or which one to
use. I want to put in a big directory with dept. names and their new
extensions. Then I want it alphabetized only. Any help would be appreciated
especialli in lame man terms.