Vlookup

M

MD2005

Is there way to control the match result in the lookup formula.
Basically, there could be five results that meet the match criteria.
Is there a way I could control the number in which the lookup pull the
informaiton
 
W

Westaradg

Some clarification on your page design, and the type of information contained
in your cells would help some.
This link may assist you, http://www.contextures.com/xlFunctions02.html
It shows how to use the (lookup formulas) and how to combine them with (if
statements) if necessary. You may also need to limit the cell range of your
lookup formula.
 
M

MD2005

The values in question are text. There could be five exact matches for
the same Vlookup. While I acknowledge that all five answers /results
are correct, I would like to tell the formula which result of the five
I want pulled
 
Top