Text to Number

[Steve]

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.

 

[Luke M]

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.

 

[Steve]

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]

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.