I have two tables where I want to have the values of column 1, 2 and 3 referenced against column 1 of Table 2 and return a value from column2 of table 2 for each value in table 1. See below
Code1, Code2, Code3
Code1, looked up description for code1, Code2, looked up description for code2, Code3, lookedup up description for code3
Any help is greatly appreciated.