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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel newbie cell update
It may well be possible to use a lookup formula to link sheet A to B but
there isn't enough information here to provide a specific example. I'd suggest looking at VLOOKUP in Help and come back with a simplified but very specific example if you cannot get it to work. You might start a new thread since this one will soon be old. -- Jim wrote in message oups.com... | 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 | |
Reply |
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 |