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.