Recent content by Nikki91775

Thank you. This is much easier than I was trying to make it.

Hi, I have a pivot table where I have pulled data for 2013. The data I have is, item number, date ordered, quantity ordered and the sales amount. So for example if I have oranges, below it it shows order date of 1/1/2013 and the amount ordered and other dates that oranges were ordered. My...

Hi everyone! I know how to use vlookups, hlookups, etc. However, I am wondering if there is a formula in Excel that can help me with this. Say I have actual 2013 numbers by month. Jan, Feb, Mar and so on. Under each of the months I have actual sales numbers and some months have a return...

Hi - I cannot use dropbox as it is blocked on our servers. Does it reside in the Excel template file that is loaded with Windows?

Hi Everyone! I do not have an issue, but I am looking for some guidance from the advanced users on a budget spreadsheets for business. I have Googled budget spreadsheets and it mostly personal out there. Here is my situation. I have to run it by distributor by month and at this point under...

Hi - I actually got it playing around with it. I needed to specific in the match where to look. =VLOOKUP(A4, Sheet1!A:F, MATCH( 'By Pump Size'!O2, Sheet1!A$9:F$9, 0), FALSE) Thanks for all your help.

Hi - I tried the formula and it still does not work. In my pivot - I have each size .25, .50, .75". Then I have months 1 - 5. For this year only. I have sum of extended quantity and I have sum of extended price. Here is the formula that I used and it only returned .25" instead of my...

Hi Everyone, I am working on an excel spreadsheet where I need to lookup the value of 2 items. For example, I need to lookup everything that is a .25 for sales by the month, 1, 2, 3, 4, 5 and so on. So my vlookup is this: =VLOOKUP(A4, Data!, MATCH('By Pump Size'!O2, Data!AK:AL, 2, False))...

Hi, I cannot see anything from dropbox, we have it blocked. Can you e-mail me at xxx ? Thanks.

I know some of you out there are excellent with Excel charts so that is why I posting this. I am in need of a graph that looks like a bucket in some sense. I want to show my PY Order numbers as a flat line across. Than I want to show my current year orders as another line, and we are down so...

Sorry everyone. I got it figured out after about a hour of messing with it. Somehow things were locked and not looking up properly. It is now working. You can either delete for put Solved.

I am working on a price comparison sheet. I have my overall sheet of all items numbers with pricing. I have different worksheets set up for each competitor with their similar products and their pricing. In my worksheet all my vlooksups are working well except for one of the competitors tabs...

The pivot I am pulling is from a database and I need to understand each of my distributor's, orders for this year vs. prior year and it also ranks the distrubitors based on orders - 1, 2, etc. So in my main view I have all my distributors listed in a pretty form with their numbers. I hit a...

Hi, The formula still is not working. In my pivot table - column A is the vendor name. And Odessa is listed three times. In column B is the amount of current orders. So in my main sheet - I have Odessa Listed and CYTD #'s. Usually with a Vlookup - I would click on the cell in the main sheet...

Hi Deb, thank you for your help. In your formula, where would I put my range to lookup? This is what I tried and it gave me an error. =VLOOKUP(("ODE" & *, Lookup!A278:B316, 2, No, True) I know I am doing something wrong. Just cannot figure it out. Thanks.