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 :
Can someone tell me how to apply VLOOKUP formula to B2 in Sheet1 ?.