Treat semiconductor substitute lists with suspicion unless they contain abridged specifications for each device.
With the other lists, you often have as much chance of success if you just make a guess.
Many BJTs are the original "jelly bean" devices, & can be fairly freely swapped.
Equipment manufacturers like to minimise inventory, & will use the same discrete device in a critical & non critical position.
If you need one for the former position, just steal it from the latter, & replace the one removed from that position with a "jellybean" part.
Another good trick, is to look at how another manufacturer does something.
If they use a common device, in a very similar circuit layout, there's a pretty good chance it will just "slot into" your circuit.