Dynamic Range??? Please Help
=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 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. |
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. |
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. |
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. |
All times are GMT +1. The time now is 02:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com