Hi I'm trying to pull three pieces of data from a different excel sheet based on a unique code. The 3rd column is text greater than 255 characters and cant get this to work, which appears to be causing issues. The text includes (), ', - characters also.
=XLOOKUP(C72,'AE Level'!$E:$E,CHOOSE({1,2,3},'AE Level'!$G:$G,'AE Level'!$Z:$Z,'AE Level'!$AA:$AA,'AE Level'!$GH:$GH))
Can anyone help or provide a better way to get the data from the third column.
Thanks
J
=XLOOKUP(C72,'AE Level'!$E:$E,CHOOSE({1,2,3},'AE Level'!$G:$G,'AE Level'!$Z:$Z,'AE Level'!$AA:$AA,'AE Level'!$GH:$GH))
Can anyone help or provide a better way to get the data from the third column.
Thanks
J
Last edited: