I am looking to invent a function which will look up a unique reference from a list. If it does not find the reference in the first list, it will automatically vlookup the reference from a second list. I will use FALSE to find exact match.
Any ideas?
Was playing around with IF nested and that might work. Any help would be greatly appreciated.
Ta. Colmodoc