Dynamic Range with Function "AND"

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

Hi,

I urgently need  help with this function:

=IF(AND(A2=1,B2=6,E2="Mescada"),F2,0)
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?

--
Regards,
Jeff

Replies