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