FWIW, Vlookup has it’s limitations, Lookup can throw errors I’d things aren’t sorted correctly - Match and Index seem to be much less limited.
I’m certain what I had done years ago was essentially a Vlookup, then a custom list that used that Vlookup itself whenever it was created.
Cheers guys...nothing like some spreadsheets to make the night pass.
__________________
No, no…I’m not sloppy, or lazy. This is a sign of the boredom.
|