Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Vlookup - Range
I have a price list i want to add items to on the second tab of my quotation
spreadsheet. Now when i highlight the 3 coloumns and including the new items i've added i name it in the top left box like usual but it doesn't save the new items. so when i go to the quotation template and enter the new part number the price and description field stay blank. How do i add items and rename it?? |
#2
|
|||
|
|||
You need to delete the old name first and then re-name.
OR insertnamedefinemyname refers to =offset($a$1,0,0,counta($a:$a),3) then the range will self adjust based on the items in col a -- Don Guillett SalesAid Software "Mark" wrote in message ... I have a price list i want to add items to on the second tab of my quotation spreadsheet. Now when i highlight the 3 coloumns and including the new items i've added i name it in the top left box like usual but it doesn't save the new items. so when i go to the quotation template and enter the new part number the price and description field stay blank. How do i add items and rename it?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range for Function (Vlookup etc) | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup of parts of a word in a range of Data | Excel Discussion (Misc queries) | |||
How do I use Range Names listed in a VLookup table in a formula? | Excel Worksheet Functions |