Hi,

I am having trouble referencing an array of cells within the IF
function, which need to be searched for a certain criteria.

I need the formula to search for a criteria, and if found return the
value next to the criteria.

If the criteria is not found then I want value next to another fixed
criteria (which I know will always be there) to be returned.

Any suggestions?

Thanks


--
selvaraj
------------------------------------------------------------------------
selvaraj's Profile: http://www.excelforum.com/member.php...o&userid=25674
View this thread: http://www.excelforum.com/showthread...hreadid=390928