Dynamic Range??? Please Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

=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.
 
What determines the bottom of your list? Col a, b or c?
on the sheet where the list is>insert>name>define>name 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))
 
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
 
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.
 
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.
 
Back
Top