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!