VLOOKUP requires that the value you are looking up be in the leftmost column of your "Data Table." So if you want to get the operation name SCD code, your ID number must be to the left of it. The third argument tells vlookup how many columns to offset to the right of the first (left) column of your lookup table matrix (cell range).
So, to l\use VLOOKUP, you need to move the ID Number column ot the left of the operation name and also make the ID Number column the first column of the range you are using in the vlookup table.
Please help Oz share knowledge among all users by posting your questions in a public forum rather than using a Private Message.