About Us

Send one of us a SMALL workbook to look at

--
Don Guillett
SalesAid Software

"Roelamp" wrote in message
...
Hi again,
it is not working and i can't figure out why. it's still not accepting it
on
my worksheet.
i did the mylist thing, where does the "then" formula go? I tried several
different ways. Thank you for trying to help me and sorry to be a pain.

"Bob Phillips" wrote:

It must be column A, that is the id column.

You must add the item to the master sheet.

The formula to define 'mylist' should be

=OFFSET($A$2,0,0,COUNTA($A:$A)-1,3)

if row 1 is ued as a heading. Make sure that you are on the master sheet
when you define this n amed range.

--
HTH

Bob Phillips

"Roelamp" wrote in message
...
OMG...I know I'm getting closer I hope...it is column A that I would
like
to
add to.

Before I get you confussed which I do easily...my list is on another
sheet
as in my formula. On my working sheet I have a drop down box, once
this is
done can I just type the new item in my working sheet, or does it have
to
be
done on the master sheet? Sorry for sounding so stupid! Thanks

"Don Guillett" wrote:

What determines the bottom of your list? Col a, b or c?
on the sheet where the list isinsertnamedefinename it mylist or
whatever
in the refers to box type

=offset($a$2,0,0,counta($a:$a),3)
then =IF(C7="","",VLOOKUP(C7,mylist,2,0))

--
Don Guillett
SalesAid Software

"Roelamp" wrote in message
...
=IF(C7="","",VLOOKUP(C7,'Sheet3 (2)'!$A$2:$C$152,2,FALSE)) this is
my
formula
I would like to be able to add the list. I tried following the
dynamic
range
instrutions but it's not working. Thank you

hen I add to the list I want some with the formula and so without.
Is
that
possible.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Dynamic Range for Function (Vlookup etc)	IshtiaqM	Excel Worksheet Functions	4	March 27th 05 09:47 PM
Dynamic Print Range Help	waxwing	Excel Worksheet Functions	2	February 21st 05 03:47 PM
Add up a Dynamic Range with 2 Variables	John	Excel Worksheet Functions	2	January 15th 05 05:03 PM
Add up a Dynamic Range with 2 Variables	John	Excel Worksheet Functions	1	January 15th 05 02:23 PM
Add a Dynamic Range with 2 Conditions Q	John	Excel Worksheet Functions	7	December 23rd 04 02:58 PM

Menu

About Us