Hi,
I need help trying to create a an index and match formula.
If the below cell starts with ma and the cell is J25 is equal to 1000 BASE-LX, 1000 Base-SX or 10GBBASE-LR I want it return the following:
" ##### PLEASE NOTE THE EAD MULTI-CHASSIS IS LOCATED IN A DIFFERENT RACK TO THE ALLOCATED SWITCH. THEREFORE FE WILL NEED TO ALLOW FOR LONGER CAT5 CABLING FOR THIS JOB ##### "
if it contains: RJ45 or 1000 Base-T I want it to return the following:
" ##### PLEASE NOTE THE EAD MULTI-CHASSIS IS LOCATED IN A DIFFERENT RACK TO THE ALLOCATED SWITCH. THEREFORE FE WILL NEED TO ALLOW FOR LONGER CAT5 CABLING FOR THIS JOB ##### "
Any help is appreciated!
