How to get vlookup to display without changin Closed

Question

Hello,

The Problem: using Vlookup formula (* =VLOOKUP(A5,$A$1:$A$9,2,FALSE)), I cannot get column results to work in A5 or A6 (as shown below - just #N/A or REF!). Eventually, I managed to get A2 match values to display (by moving Column A2 to A1).  What was blocking the result?

$List$  Match Type(t)  Score          t1 total      t2 total
A1      A2      A3       A4                A5           A6 
1        3                  5   jobs        #N/A            #N/A
2        4        t1       0   jobs        0   jobs         #N/A
4        5        t2       25 jobs        #N/A             25 jobs
5        6                  0   jobs        #N/A            #N/A
7        7        t2       5   jobs        #N/A            5 jobs     
8        8        t1       14 jobs        14 jobs         #N/A  
9        9        t2       70 jobs        #N/A            70 jobs
-------------------------------------------------------------
                                                14 jobs         100 jobs    

Actually, I created a workaround using =VLOOKUP(A4,$B$4:$B$279,1,FALSE), but I had to change the layout of the table (by moving the A2 column to A1).

venkat1926 · Answer

little confusing. your column heading A5 is like to be confused with cell A5(5th row 1st column ). 
in the formula 
=VLOOKUP(A5,$A$1:$A$9,2,FALSE))
what is A5 and what is 2. 

what do you want to find. 

in the vlookup formula the first argument must be the first column in the second argument reference range .  Otherwise use index-match function.

How to get vlookup to display without changin

1 response

Similar discussions

Subscribe To Our Newsletter!