Lookup a field within same table?

Yes, a table can be related to itself. Or you can use a Formula Query. Can you better describe your use case?