Lookup, but "embedded"

Ok, so you DO have a list. Step 1, check. As I see it, you have two decent options:

1. Keep your list of GL Codes and their descriptions in a separate Excel file. Use VLOOKUP or other lookup formulas to pull the description into your primary sheet that you're going to use for SAP. Once the lookups have done their job (and you see all of the descriptions) select that column, copy it and then PasteSpecial->Values on top of itself. Then you won't have any links to another document, just the values.

2. Since you only have about 15-20 codes, you can use VBA such as a Select Case and a loop through your GL code data. For example, if your GL Codes are in column A, and you want the Descriptions in column B:

Sub findGL()
    Dim i As Long
    
    For i = 2 To Range("A65536").End(xlUp).Row
        Select Case Cells(i, 1)
            Case "1234-5678", "4567-8901"
                Cells(i, 2) = "Engineering"
            Case "2345-6789"
                Cells(i, 2) = "Production"
            Case "3456-7890"
                Cells(i, 2) = "Sales"
            Case Else
                Cells(i, 2) = ""
        End Select
    Next i
End Sub

Hi again, Zonino.

To use as a function, place this code into a standard module:

Function FINDGL(rng As Range)
    Select Case rng.Text
        Case "1234-5678", "4567-8901"
            FINDGL = "Engineering"
        Case "2345-6789"
            FINDGL = "Production"
        Case "3456-7890"
            FINDGL = "Sales"
        Case Else
            FINDGL = ""
    End Select
End Function