Trying to put multiple IF/OR functions in a sheet

[crispybadger]

Hi Guys,

Wonder if any one can help. I have only been having partial success.

I want to use an IF/OR function in the summary sheet in cells B2,C2,D2 based on the input in the Select sheet.

I need for B2,C2,D2 etc to mirror what is in either B3, H3, N3 in the select sheet

I can get it to work if all 3 have inputs but there will be times when only 2 or 1 of B3, H3 or N3 will be populated with either Remove, Re-Use or Swap. But it still needs reflect in the summary.

For all TMA requirements that are not used they will be input as N/A, as is in the drop down. But this cannot affect the outcome. If only 2 cells are used they will always be the same. I.E if B3 says Remove, the other cells that are applicable will say the same.

I have been playing around with the below in the larger sheet but I just cant tweak it right.

Can anyone use a similar function in the attached sheet, I can then hopefully take it from there.

=IF(OR('10. Antennas & Rigging'!B14="Swap",'10. Antennas & Rigging'!B14="Remove"),'10. Antennas & Rigging'!B14,IF(OR('10. Antennas & Rigging'!F14="Re-Use",'10. Antennas & Rigging'!F14="Remove"),'10. Antennas & Rigging'!F14,IF(OR('10. Antennas & Rigging'!J13="Remove",'10. Antennas & Rigging'!J14="Remove"),'10. Antennas & Rigging'!J14,"Re-Use")))

Many Thanks in advance, sorry if I have over confused things

[Ace_XL]

Perhaps, in B2 use

=IF(OR(Select!B3={"","N/A","Select"}),IF(OR(Select!H3={"","N/A","Select"}),IF(OR(Select!N3={"","N/A","Select"}),"",Select!N3),Select!H3),Select!B3)

and copy across

[crispybadger]

Hi Ace,

Works great. I did manage to get it sorted in the end, but I couldnt get the blank if N/A was selected across the board. So thank you very much.

Regards