How to do this??

[Lewis Koh]

I'm trying to do the following. Sheet 2 is initially blank until user input in column A. Column B will depends on column Sheet2's column A's input and grab data from Sheet 1 according to what was input into Sheet2's column A's input.

I know there is a way to do if loops many many times but it's not logically to do if conditions for 130 items. Any possibility of shortening this process?

On Sheet 1:
A1 = 1, B1 = Class 1
A2 = 2, B2 = Class 2
A3 = 3, B3 = Class 3
A4 = 4, B4 = Class 4
A5 = 5, B5 = Class 5

On Sheet 2:
A1 = 3, B1 = if(A1=Sheet1!B3,""),
A2 = 1, B2 = if(A2=Sheet1!B1,""),
A3 = 2, B3 = if(A3=Sheet1!B2,""),

[DonkeyOte]

Lewis Koh, you've been a member long enough to know the rules re: thread titles.

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.