Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Try:
=IF(I5="Executive Consultant",I5,IF(AND($A7=$A5,$I7="Executive Consultant"),$I7,"")) "andyp161" wrote: Thank you - this works great. I am also trying to make the following work, without much success - can you help? =IF((I5="Executive Consultant"),I5),OR(AND($A7=$A5,$I7="Executive Consultant"),$I7) e.g. IF I5 = "Executive Consultant" then return I5, OR if A7 = A5 AND I7 = "Executive Consultant" return I7. Many thanks -- andyp161 ------------------------------------------------------------------------ andyp161's Profile: http://www.excelforum.com/member.php...o&userid=11654 View this thread: http://www.excelforum.com/showthread...hreadid=534558 |