Automate vlookup in spreadsheet

Question

I'm kinda stuck with this spreadsheet lookup. I've Spreadsheet A and Spreadsheet B: Sheet A Sheet B

Col A ColB ColA ColB

                        1     Damaged
                        2     Rework Needed
                        3     Customer Reject
                        4     Lost
                        5     Poor Quality

I need to automate this using Vlookup so that when user enters value say (1 or 2) in Col B of spreadsheet A then Col A of (Spreadsheet A) will show the values from Spreadsheet b (Damaged, Rework needed, etc)

Answer 1

Unless I am missing something, It should just be a simple vlookup in column A.

=VLOOKUP(B1,Sheet2!A:B,2,FALSE)