fxMicrosoft Tools
Excel Formula Builder
Select a common Excel formula and fill in the parameters with plain-English descriptions. Get a ready-to-paste formula string without memorising syntax.
Search a column for a value and return data from another column in the same row.
The value to search for
The range containing the data
Column number to return (1 = first column)
FALSE = exact match, TRUE = approximate
=VLOOKUP(A2, Sheet2!A:D, 3, FALSE)