Forum Discussion
Need help with reference
I have a list of names in a sheet and I use them in another sheet. The problem is that I always have to add new names in the list of names and I want them to appear in alphabetical order. When I reor...
Marcello,
don't use direct references like Sheet1!A4 but lookup functions like VLOOKUP(), LOOKUP() or INDEX(MATCH()).
Thanks Detlef!