Hello

I have a "raw data" sheet of 1500 rows and 30 columns.... in columns J, K,
L, M, T, W are names of people. In the "Lookup" sheet I have a list of
leavers (I have defined the list). In the last column of the "Raw Data" sheet
I need to bring back the Name/s of the leaver/s if mentioned in columns J, K,
L, M, T, W.
I know I need to use a nested formula just which ones?

You help is greatly appreciated!!