If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Text to Number
I have over 50 items with multiple price points. I can not seem to figure out
how to make the price automatically fill in once I either import or type in the product name. To confuse things even more, my prices change every so often. Is there a way that i can do this or must i continue to input the prices in manually. Below is the column headings. It might be of some assistance. Customer Category Product Quantity Price Extended Price Date Week Any help? Also, Is there a way i can convert a date into a specific week number. My week begins on Wednesdays. |
#2
|
|||
|
|||
Text to Number
Sounds like you want to look at the VLOOKUP (fairly simple, setup a table and
go) and WEEKNUM functions. (By default uses Monday/Sunday as beginning date, but you can prb do something like =WEEKNUM(YourDate+4) which would be close. Error might pop up when you are close to beginning/end of year. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Steve" wrote: I have over 50 items with multiple price points. I can not seem to figure out how to make the price automatically fill in once I either import or type in the product name. To confuse things even more, my prices change every so often. Is there a way that i can do this or must i continue to input the prices in manually. Below is the column headings. It might be of some assistance. Customer Category Product Quantity Price Extended Price Date Week Any help? Also, Is there a way i can convert a date into a specific week number. My week begins on Wednesdays. |
#3
|
|||
|
|||
Text to Number
Luke,
I am setting up a pivot table to track sales. I have never used the VLOOKUP function but i have read up on it and am unable to understand it. As for the WEEKNUM, that helped. Thanks. "Luke M" wrote: Sounds like you want to look at the VLOOKUP (fairly simple, setup a table and go) and WEEKNUM functions. (By default uses Monday/Sunday as beginning date, but you can prb do something like =WEEKNUM(YourDate+4) which would be close. Error might pop up when you are close to beginning/end of year. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Steve" wrote: I have over 50 items with multiple price points. I can not seem to figure out how to make the price automatically fill in once I either import or type in the product name. To confuse things even more, my prices change every so often. Is there a way that i can do this or must i continue to input the prices in manually. Below is the column headings. It might be of some assistance. Customer Category Product Quantity Price Extended Price Date Week Any help? Also, Is there a way i can convert a date into a specific week number. My week begins on Wednesdays. |
#4
|
|||
|
|||
Text to Number
Vlookup example:
On a seperate sheet (called Table), make a list of your products in column A. Let's say apples, bananas, oranges. In the column next to that, list the prices ($10, $20, $25) Now, on your main sheet, say you input "oranges" into cell A2. This formula =VLOOKUP(A2,'Table'!$A$1:$B$3,2,FALSE) would return $25. Basically, Vlookup looks for a specific value withing one columns, and then pulls the corresponding value from a nearby column. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Steve" wrote: Luke, I am setting up a pivot table to track sales. I have never used the VLOOKUP function but i have read up on it and am unable to understand it. As for the WEEKNUM, that helped. Thanks. "Luke M" wrote: Sounds like you want to look at the VLOOKUP (fairly simple, setup a table and go) and WEEKNUM functions. (By default uses Monday/Sunday as beginning date, but you can prb do something like =WEEKNUM(YourDate+4) which would be close. Error might pop up when you are close to beginning/end of year. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Steve" wrote: I have over 50 items with multiple price points. I can not seem to figure out how to make the price automatically fill in once I either import or type in the product name. To confuse things even more, my prices change every so often. Is there a way that i can do this or must i continue to input the prices in manually. Below is the column headings. It might be of some assistance. Customer Category Product Quantity Price Extended Price Date Week Any help? Also, Is there a way i can convert a date into a specific week number. My week begins on Wednesdays. |
Thread Tools | |
Display Modes | |
|
|