Dynamic Range with Function "AND"

Giganews Newsgroups
Subject: Dynamic Range with Function "AND"
Posted by:  Jeff
Date: Wed, 24 May 2006


I urgently need  help with this function:

The problem that I have is that sometime the value that I look up for is not
located on row 2. It could be on row 5 or 11 depending on the size of my file.
Is there anyway I could make a generic function that would allow me to look
up my value in range instead of a row?