I have actually solved this myself with some help from alan in chinks
post. thanks.
=IF(AND(H60,I60),I6,IF(AND(H60,J60),J6,IF(AND( H60,K60),K6,0)))
but now have a new problem.....
because A B C & D get their values from lookups, if the look-up cannot
find a value it is returning #N/A in some of these cells.
this is not a problem but it means that #N/A is shown in Z (above
example) for B, when it should be the value of C or D.
Can i force excel not to accept #N/A ?
--
chrisabberton
------------------------------------------------------------------------
chrisabberton's Profile:
http://www.excelforum.com/member.php...o&userid=16872
View this thread:
http://www.excelforum.com/showthread...hreadid=320531