Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel newbie cell update
Sorry know this is pretty basic stuff here I think. I have a formated
price sheet called sheet A which consists of product names and a pricing table for each product. the layout for a few products is like this; product A8, sizes C11-14 and price E11-14, Product A17, sizes C20-25, price E20-25. On sheet B you have 3 columns, Product A1-200, Sizes B1-200, Prices C1-200. This sheet changes on a regular bases and can vary in size. Is it possible to update Sheet A prices with a Vlookup in this situation or what can I use to make this work in excel. Any input would be great. I am pretty new to this. Thanks for your help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |