mepalival

//Convert Event,Age Group,Gender with Range Value 
Convert_Event_AG_Gen=
  LAMBDA(AgeGroupValue,GenderValue,EventValue,RangeLookup,
    TEXTJOIN("#",TRUE,
    IFERROR(VLOOKUP(EventValue,RangeLookup,2,FALSE),"NotFound"),
    IFERROR(VLOOKUP(AgeGroupValue,RangeLookup,2,FALSE),"NotFound"),
    IFERROR(VLOOKUP(GenderValue,RangeLookup,2,FALSE),"NotFound"))
  );