A quick question on VLOOKUP.

I have two sheets ("Sheet2" acting as source or list of elements and "Sheet1" is where the VLOOKUP formula will be used)

I have created a name so that I can reuse the vlookup formula for A2 (Sheet1) also.

The issue is when I drag the formula to B2 in Sheet1 (where I want the VLOOKUP to be applied) it is showing me error and upon inspection I found that the variable I created "qw" is dynamically changing for every row.

See below :

QUESTION :

Can someone tell me how to apply VLOOKUP formula to B2 in Sheet1 ?.