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!