Vlookup with Match - no results issue
 

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.

Vlookup with Match - no results issue
 

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.

Vlookup with Match - no results issue
 

yes I did use an = sign it just didn't get added to my cut/paste. The cut
and paste actually came from another post here. So this is my exact formula.


=VLOOKUP(F8,'Key Counts'!A5:T1500,MATCH('Qrtly Forecast by Route'!I6,'Key
Counts'!E4:T4,0),0)

I ask about the final zero because if I remove this portion of the formula,
I get results albeight wrong and blank, but at least the visual formula goes
away. There is an exact match in the table I am searching.



"PJFry" wrote:

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.