VLOOKUP - avoiding left column rule

G

grphillips

Thanks guys, I havn't tried it yet. I am still trying to understand i
by reading. Does it give an exact match like vlookup
 
D

Dave Peterson

The 3rd parameter in =match() corresponds to the 4th parm in =vlookup().

So you can specify an exact match if you want.

From mzehr's post:
=INDEX(ReturnValueRange,MATCH(LookupValue,MatchValueRange,0))

That 0 is the parm that's important.
 
Top