VLOOKUP - avoiding left column rule

  • Thread starter Thread starter grphillips
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vlookup challenge with hyphen data placement 2
VLOOKUP - avoiding left column rule 3
Some rules about Vlookup 2
Some rules about Vlookup REPOSTED 6
Excel Vlookup Help 0
Vlookup with Multiple Rows to match with one row 1
VLookup 1
Selecting an unmatched value 1

Back
Top