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!

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!

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!