Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Tricky if function
I am looking to create an IF function, but I need to draw information off
another sheet, is this possible? And how do I create the function with between values too? Example of what I am trying to do: If Sheet 1 A1 is between 200- 300, I need the values from Sheet 2 A3, A4, A5 to be inserted into Sheet 1 B2, B3, B4. If Sheet 1 A1 is between 300-400, I need the values from Sheet 2 B3, B4, B5 to be inserted in the Sheet 1 B2, B3, B4. If Sheet 1 A1 is between 400-500, I need the values from Sheet 2 C3, C4, C5 to be inserted in to Sheet 1 B2, B3, B4. Any and all help is much appreciated!! THANKS IN ADVANCE! Have a wonderful day! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Tricky if function
In another cell, say H10 enter:
=INT(A1/100)-1 then in B2 thru B4 enter: =CHOOSE(H10,Sheet2!A3,Sheet2!A4,Sheet2!A5) =CHOOSE(H10,Sheet2!B3,Sheet2!B4,Sheet2!B5) =CHOOSE(H10,Sheet2!C3,Sheet2!C4,Sheet2!C5) -- Gary''s Student - gsnu200774 "hlpme" wrote: I am looking to create an IF function, but I need to draw information off another sheet, is this possible? And how do I create the function with between values too? Example of what I am trying to do: If Sheet 1 A1 is between 200- 300, I need the values from Sheet 2 A3, A4, A5 to be inserted into Sheet 1 B2, B3, B4. If Sheet 1 A1 is between 300-400, I need the values from Sheet 2 B3, B4, B5 to be inserted in the Sheet 1 B2, B3, B4. If Sheet 1 A1 is between 400-500, I need the values from Sheet 2 C3, C4, C5 to be inserted in to Sheet 1 B2, B3, B4. Any and all help is much appreciated!! THANKS IN ADVANCE! Have a wonderful day! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Tricky if function
One way:
=IF(AND(Sheet1!$A$1200,Sheet1!$A$1<300),Sheet2!A3 ,IF(AND(Sheet1!$A $1300,Sheet1!$A$1<400),Sheet2!B3,IF(AND(Sheet1!$A $1400,Sheet1!$A $1<500),Sheet2!C3,""))) Put this formula in Sheet1!B2 and fill down to B4. Assuming Sheet1 and Sheet2 are the actual names of your sheets, of course. HTH, JP On Mar 19, 12:41*pm, hlpme wrote: I am looking to create an IF function, but I need to draw information off another sheet, is this possible? And how do I create the function with between values too? Example of what I am trying to do: If Sheet 1 A1 is between 200- 300, I need the values from Sheet 2 A3, A4, A5 to be inserted into Sheet 1 B2, B3, B4. If Sheet 1 A1 is between 300-400, I need the values from Sheet 2 B3, B4, B5 to be inserted in the Sheet 1 B2, B3, B4. If Sheet 1 A1 is between 400-500, I need the values from Sheet 2 C3, C4, C5 to be inserted in to Sheet 1 B2, B3, B4. Any and all help is much appreciated!! THANKS IN ADVANCE! Have a wonderful day! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A Tricky One...... | Excel Worksheet Functions | |||
Help With A Tricky SUMPRODUCT Function | Excel Worksheet Functions | |||
Tricky FV function | Excel Worksheet Functions | |||
Is it just me or is this tricky? | Excel Discussion (Misc queries) | |||
Tricky maybe | Excel Worksheet Functions |