Excel Lookup Series #14: CHOOSE function

Hello,

I have a simple question that I have had a difficult time answering, is there a way to make the Vlookup function return a formula like the Choose function does?

Instead of changing the value1, value2,.. in the Choose function within a cell I would like to change the formula in a table that is looked up by the Vlookup function.

Is this possible to do?

Thank you for your help!

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?

example of my problem:
I have a list of names across the top row
Below each name I have numbers that represents the electric bill for the month

I want to, in another cell, display the building name that whose electric bill is the largest.

I have tried playing with "choose" and "max", but cant get the combination to work. What am I doing wrong?

see below for example:

bldg-a bldg-b bldg-c
123 124 125 Largest Bill: bldg-c

I have the following data plotted on a chart:

DATE | Firm1 | Firm2 | Firm3 | Firm4 |
8 JUL
9 JUL
10 JUL

I want the user to have control as to plot all the firms, {firm1, firm2}, {firm1}, etc......the control could be from a drop down.

Please help!

I'm trying to set up a report that calculates fees in order to validate fee
calculations on another system. Column one contains a reference to a fee
schedule; i.e. schedule A, schedule B etc. Column 2 contains the account
value. So I need to look up the appropriate schedule, use the appropriate
calculator and return the result into column 3. Part of my problem is that
the fee calculators are not in a single cell, although I could probably
re-write them if I have to. (The fee calculators discount for higher
balances- i.e. 1.00% of the first $500,00, .85% of the next $500,000, .75% of
the next $1,000,000, etc) Any ideas and/or formatting suggestions would be
appreciated!

I've been trying to wrap my head around the Choose function and its application. I can't think of a reason to use Choose instead of Lookup.

Can anyone give me some good examples instead of links to pages I've probably already not understood?

Hi, why isnt this formula returning "" for Test3

Sheet3

  A B C D E F G 5 Test1 0.06       Test1 0.06 6 Test2 0.05       Test2 0.05 7           Test3 #N/A 8               9               10              
Spreadsheet Formulas Cell Formula G5 =LOOKUP(9.99999999999999E+307,CHOOSE({1,2},"",INDEX(B:B,MATCH(F5,A:A,0)))) G6 =LOOKUP(9.99999999999999E+307,CHOOSE({1,2},"",INDEX(B:B,MATCH(F6,A:A,0)))) G7 =LOOKUP(9.99999999999999E+307,CHOOSE({1,2},"",INDEX(B:B,MATCH(F7,A:A,0))))

Excel tables to the web >> Excel Jeanie HTML 4

Hello Everyone,

Below is an array formula that was greatfully supplied by Aladin and it was working perfect for me but I have only just noticed that the search for "X" and "H" are working fine but the "U/P" and "PP" and not. If I swap to "H" and "U/P" around then the U/P will work but not the H. So my guess is that it is only searching for the first 2 and not the rest. And by the way when Aladin gave me the below formula it was only meant to lookup 3 criterias not the 4 criterias that is now doing. My guess is that it could have something to do CHOOSE({1;2} which I have played around with but of cause so far with no luck.

Code:

 
{=LOOKUP(REPT("z";255);CHOOSE({1;2};"";INDEX({"X";"H";"U/P";"PP"};MATCH(INDEX('Graphic 2nd Half'!$F$4:$GE$123;MATCH($C12;'Graphic 2nd Half'!$C$4:$C$123;1);MATCH(T$1;'Graphic 2nd Half'!$F$2:$GE$2;1));{"X";"H";"U/P;""PP"};0))))}

Any help with trying to solve the above formula will be greatly appriciated.

Paul

Mocow

I have an urgent problem with the lookup formula:
Example:
If I have in Cell A1 the Word: A
If I have in Cell B1 the Word: aa

In Cell C1 i have the formula: Lookup("ab";B1;A1)

The answer is A.

Why does excel display A as an answer? I looked for "ab" and not for "aa"!!!

I don't see the mistake!