Are you adding the = in front of the formula?
=VLOOKUP("Single",$A$1:$D$4,MATCH("Termo",$A$1:$D$ 1,0),0)

The 0 means that it will only return exact matches. It works the same as if
you used FALSE.
=VLOOKUP("Single",$A$1:$D$4,MATCH("Termo",$A$1:$D$ 1,0),FALSE).
--
Regards,

PJ
Please rate this post using the vote buttons if it was helpful.



"JICDB" wrote:

I am trying to use a Vlookup to look up the left most field of a table, in
another worksheet and return the match of the column heading. I am not
getting results, just the formula itself. From everything I've read here it
is because of a data mistmatch but I cannot seem to be able to fix it even
though I sinked up all of the data types and retyped the formulas.

Does anyone know a way to fix this?
What does the last zero mean in the vlookup/match formula below?

VLOOKUP("Single",$A$1:$D$4,MATCH("Termo",$A$1:$D$1 ,0),0)

Thanks for your help in advance.