Ok, so if I understood your question correctly, then you could use dynamic sql, something like following:
declare @name nvarchar(50)
set @name = (select Name from Lookups where Lookups.ID = 4)
execute ('select * from ' + @name)
For more information, see
EXECUTE[
^]