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.


"MD2005" wrote:
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