Started using VLOOKUP yesterday. Used it for the first time. Now when applying it to the following scenario, it's returning the same value as the result, which I am "looking for" in the other column.
That is, I am trying to find the names (as listed in the second column), corresponding to the numbers in the last column. (first two column is the data which I already have at my disposal) and it is the last column, corresponding to which, I have to find the names, as listed in the second column.
Note: Taken only 3 rows of data, however, the data consists of 50 entries in the first 2 columns.
In the last column, I have 49 entries in all and I am supposed to look up the values of the last column, within the first column, and get the corresponding names from the second column.
Let's name the existing columns as A, B, C, D, E, F
I started appluing the Vlookup in C1, by placing the cursor in it, as follows:
=VLOOKUP(F1, A1:B50,1,0) (as it is already mentioned that A and B columns have 50 data points.
Result obtained in column C: I am getting the corresponding values of column F itself, in majority (matching with each other, wherever obtained), else NA.
when tried using without the excat match, that is without zero, it again produces the numbers in column c, as listed in column f, but this time producing even more absurd results, as there are no matches or corresponding values produced (as in the above case)