Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
if funkcion
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
if funkcion
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. "Johaidis" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
if funkcion
=(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" Newsgroups: microsoft.public.excel.programming Sent: Wednesday, December 23, 2009 10:23 AM Subject: if funkcion 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 "Johaidis" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF funkcion example | Excel Discussion (Misc queries) |