Jun 14 2019 12:03 AM
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.
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)
2658820821 | MBAW | 1540217574 | |||
1540217574 | MBMS | 2658820821 | |||
3514190626 | MBGAM | 3514190626 |
Jun 14 2019 12:53 AM
Jun 14 2019 01:06 AM
Hey @Wyn Hopkins , Thanks for replying, yes, it is giving the values, when I had put B50,2,0.................
However, initially, when I was using B50,1,0....it was just reproducing the values in column F.
Now, please help me with the logic behind putting B50,2,0 and not B50, 1,0.
Also, please note that I do not have any headers in the respective columns, hence, each of the columns start from first row itself, ie. A1, B1, F1.
Remark: To some extent I had just mugged up one way of applying Vlookup after seeing an example through Google, hence, not very sure about the logic behind B50,2,0 and not B50,1,0.
Regards,
exceluser
Jun 14 2019 01:16 AM