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