if funkcion

[Johaidis]

Hello,
I would like to ask for help on logical formula.
I have 2 sheets on exel document. In first sheet I have basic information on
two colomns -number- first colon ,text other colomn . In other sheet I have
infomation I have to work on.
In the second sheet I would like to make such a formula like entering number
1 from the other sheet it will give me all informations and enter this
information in cell. Problem is that I have numbers 1-30 for my given
information but "if" logical function doesn't support so many arguments...
I mean like this:
=IF(G3="1-1";'sheet 1'!$B$4;IF(G3="1-2";'sheet 1'!$B$5;IF(G3="1-3";'sheet
1'!$B$6;IF(G3="1-4";'sheet 1'!$B$7;IF(G3="1-5";'sheet
1'!$B$8;IF(G3="1-6";'sheet 1'!$B$9;IF(G3="1-7";'sheet
1'!$B$10;IF(G3="1-8";'sheet 1'!$B$11)))))))
in formula I wrote I could just enter 8 numbers.

Can you help me????
Thank,
Johaidis

 

[B Lynn B]

It looks like you just need to use VLOOKUP function instead, in conjunction
with a small table holding your lookup values and results to return. Try
googling "excel vlookup tutorial" for lots of options for seeing how it works
if you're not already familiar with it.

 

[helene and gabor]

=(CHOOSE(IF(ISNUMBER(VALUE(MID(G3,5,1))),10*VALUE(MID(G3,4,1))+VALUE(MID(G3,5,1)),VALUE(MID(G3,4,1))),"'sheet1'!$B$4","'sheet1'!$B$5"))

Hello,

Your problem is set up for a max. of 99 possible G3 values. ("1-1",
"1-2",......"1-98", "1-99").
I have only entered two items: 'sheet1'!$B$4 and "sheet1"!$B$5 as you can
see in the last line of the formula. You could enter as many values as you
want.
It worked for me.

Regards,

Gabor Sebo




----- Original Message -----
From: "Johaidis" <[email protected]>
Newsgroups: microsoft.public.excel.programming
Sent: Wednesday, December 23, 2009 10:23 AM
Subject: if funkcion