Excel Lookup Series #4 PART 1: VLOOKUP Function 4th Example

Just got an e-mailed file, that has a line graph with a feature I want to be able to replicate.

It's a single series, but the first 10 points are connected with a solid line, and the last 10 are connected with a dashed line.

How's that possible? Excel 2007.

Q. Is there a way of combining the =series function with the =lookup function?

In the example below I would like sheet 1, B1 to lookup the value sheet1, A1 in sheet lookup (Lookup!A1:D3) and then give the series of numbers to the right of the found result. Hopefully the figures below explain what I mean a little better.

In sheet 1:
A1 = Summer
A2 = Spring
A3 = Winter

B1=SERIES(,,Lookup!$B$1:$D$1,1) - this gives series for Summer

In Lookup Sheet:
A1 = Summer, B1 = 1, C1 = 2, D1=7
A2 = Spring, B2 = 10, C2= 22, D2=17
A3 = Winter, B3 = 0, C3= 23, D3=37

Any advice appreciated

Thanks

Joe

I have time series price data. For each date and price, I want to return the
very next date in which the price has dropped more than 10 cents.

How can I do this?

Look up each item's price in the product prices table ( lower left hand corner) and display the price in column C of the invoices table ( use a vlookup) The extended cost is the quanitity times the price. The shipping cost is computed by in column F by looking up the shipping rate and multiplying it by the extended cost ( column E). Column G is the sum of the extended cost and shipping cost.
*Shipping rate in lower right hand corner goes from ( 32 to 35, including headers)
* Column starts from a to G
* Rows go from 22 to 28 (including headers)
* Prices product table starts from 32 to 36 (including headers)

So far I have:

Customer Item Price Quantity Extended Shipping Total 90273 toothbrush 1 90310 music player 1 90291 radio 2 90312 toothbrush 3 90303 radio 1 90389 toaster 3 Item Price Extended$
Rate music player $91.45 0 1% radio $65.00 10 5% toaster $27.00 100 10% toothbrush $12.50

Hi All,

I have got a new thing to make in access and will need help of all of you!!! This is going to be big and as my knowledge of access is limited thats why I'll ask the questions, in a series starting from this question!!!!

Hope it will be a good mental exercise for all of you!!!!

Here we go now!!! I have got a table which consists of nearly 10000 rows. These rows have got customer's unique ID and the total amount spend by them. But the same customer ID can be repeated "n" number of times. I need a macro which can sum up the whole cost per customer id.

e.g.

Chris $1
Chris $2
Roy $3
Oliver $4
Oliver -$2

and after running the macro the data should look like

Chris $3
Roy $ 3
Oliver $2(as there is -ve sign in raw data, it should get subtracted)

Hoping I have cleared myself here. Please revert in case of further questions.

Thanks in advance for helping me out!!!!!

Hi

Just need some help as to which function I use. I have a figure in say A1
that I want to match to the same figure in another worksheet in column A &
return what the figure is in column B to show in A2. I've been using the
vlookup and lookup functions but just seem to get back #N/A.

Hope it makes sense, help would be much appreciated.

Hey All,

So i have been put to this challenge to do a inventory tracking sheet for my work and keep coming to dead ends. I do appreciate everyones help especially Leith Ross, Thanks again!

Here is what i am after:

I have 2 sheets, 1 has Item number, description and how many parts on hand for columns, The other has the same but with cost per unit added. Is there a way that i can use a find function of some sort to look up in the second sheet using the item number from the first (which is the same as the second) to find the cost per unit?

Thanks and much appreciated
Mikey

i have a series of part numbers in a column in xl that vary in length but
all end in "v'. I want to remove just the "v". I tried text to coulmns and
all the functions i know.

I know this must be quite simple but im not sure now to do it.

Ive got a Lookup formula like =LOOKUP(A1,B1:B5,C1:C5), and want to extend the series but so that A1 changes to A2, A3, A4 etc as i drag it down, but i want to keep tha B1:B5,C1:C5 without it changing to B2:B6,C2:C6 etc.

If someone can tell me how to do it please.

Thanks

Dan.

Hi All,

I want to find out if a changed cell was one of a number of cells.
The cells i want to test for are B10,B15,B20,B25,B30 etc. upto B80.

I can use the IF statement with a lot of ORs to check this but surely there
is another, cleaner way to do this. Can anyone tell me how?

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = "$B$10" OR
Target.Address = "$B$15" OR
Target.Address = "$B$20" OR ....... THEN

code to execute

END IF

end sub