On Wed, 30 Mar 2022 at 08:55, Mark Rogers mark@more-solutions.co.uk wrote:
Another way would be to have the shorter list in column A, the longer list in column B, and a third column that does a VLOOKUP
Example (LibreOffice Calc file): https://drive.google.com/file/d/1MSVEh8FRAlx8Pv7RyBD8Dz5WVHHNm24U/view?usp=s...
Mark