vlookup helper — free browser tool | fatcousin

build xlookup · vlookup syntax · runs locally

function

inputs

lookup valuecell reference or value to search for

table arrayrange containing the data (first column is searched)

column indexcolumn number to return (1 = first column of table array)

match type

generated formula

=VLOOKUP(A2, B2:E100, 2, FALSE)

Searches the first column of B2:E100 for A2, then returns the value from column 2. Match type: exact match (FALSE).

status

>ready

ready