Forum Discussion
EXCEL-VLOOKUP
I have a little problem with formula: VLOOKUP. I write everything ok (I think so) but my formulas aren't fullfild. I want to write that all time when somebody write their year of the birth, they wil...
From https://support.office.com/ , VLOOKUP formula is
=VLOOKUP(Value you want to look up,
range where you want to lookup the value,
the column number in the range containing the return value,
Exact Match or Approximate Match – indicated as 0/FALSE or 1/TRUE)
The first parameter of VLOOKUP is the value that you want to look up value. The second parameter is the range where you want to lookup the value, but, the first column must be the column in which the look up value is. In your case, it is not easy to know which column contains the lookup value, and the most important part is that the column would not be the first column of the range. Hence, VLOOKUP formula is not suitable on your case.
