I have a data set like below
when select the Emplyee id, i need the the Name and the department value
like below shoud be the result
New Dynamic array fomulas or Xlookup is preferred. NO Vlookup or index match.
Thanks for the help in advance
when select the Emplyee id, i need the the Name and the department value
like below shoud be the result
New Dynamic array fomulas or Xlookup is preferred. NO Vlookup or index match.
Thanks for the help in advance