Gail,

Don't hijack threads. For a new topic, start a new thread. And when you do,
make sure you include enough information so that a solution can be
proffered.

Regards,
Fred.

"Gail" wrote in message
...
I am trying to autofill data from one spreadsheet to another, can you
assist
me?

"Howard" wrote:

Thanks again. I've got plenty to work on now.
--
Howard


"Shane Devenshire" wrote:

Hi,

Just highlight a range of one of the tables and select the Name Box (on
the
left of the Formula Bar where you see the cell address) and type in a
name
like Accounting (no spaces) and press Enter. (Pressing Enter is
necessary).

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"Howard" wrote:

Hate to keep being a pest, but I'm having trouble figuring out how to
design
the table in Excel 2007 so that I name the table "Accounting", for
example.
I've tried looking at Excel Help, but no real luck.
--
Howard


"Shane Devenshire" wrote:

Hi,

That is what was suggested in effect:

=IF(A1="Accounting",VLOOKUP(C1,Table1,2,FALSE),VLO OKUP(C1,Table2,2,FALSE)

or if there are a lot of possible tables (departments) why not
something
like this:

=VLOOKUP(C1,INDIRECT(A1),2,FALSE)

In this case A1 would contain the department name and each table
would be
named with one of the department names. So if you entered
Accounting in A1
the vlookup would be doing

=VLOOKUP(C1,Accounting,2,FALSE)

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"Howard" wrote:

Thanks for the reply so quickly, but I probable didn't make
myself clear. I
want to put more than one lookup table on a worksheet, and then
different
cells would use different tables to determine a result. It seems
that I
would have to identify each table, and then the =IF function
would have to
know which table to use.
--
Howard


"Gary''s Student" wrote:

=IF(A1=1,VLOOKUP(),VLOOKUP())
--
Gary''s Student - gsnu200816