none
excel function array RRS feed

  • Question

  • Hi,

    do we have any short formula for the below,

    is it possible to put NOCR.NOT,DEALS all in one array {} and vlookup combined

    =IFNA(IF(OR(VLOOKUP($C4&$D4,Table,5,0)="NOCR",VLOOKUP($C4&$D4,Table,5,0)="NOT",VLOOKUP($C4&$D4,Table,5,0)="DEALS",VLOOKUP($C4&$D4,Table,5,0)="UNKNOWN"),VLOOKUP($C4&$D4,Pivots!$AO:$AR,4,0),VLOOKUP($C4&$D4,Table,5,0)),VLOOKUP($C4&$D4,Table,5,0))

    Wednesday, April 29, 2015 2:20 PM