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 reorder the list all its references in the second sheet gets messed up. Is there a way to solve this? TKS
Marcello,
don't use direct references like Sheet1!A4 but lookup functions like VLOOKUP(), LOOKUP() or INDEX(MATCH()).
Thanks Detlef!
