Vlookup query

Essentially I want to create a vlookup formula that when I type number 1 (TO 670) into "column E-L" it will look up 1 in in column B and return the number in column A. could anyone advise how to do this/ if this is possible? I can even have column A +B on a separate spreadsheet if required.



A B C D E F G H I J

REF NUMBER 1 2 3 4 5 6 7 8
4921 1 1
4922 2 2 1
4920 3 3 2 1
4924 4 4 3 2 1
4926 5 5 4 3 2 1
4928 6 6 5 4 3 2 1
4930 7 7 6 5 4 3 2 1
4932 8 BREAK BREAK BREAK BREAK BREAK BREAK BREAK

Hey I have attached my spreadsheet