Think of a cartridge like you spitting those paper spit balls through a straw. Try to follow my logic...
An overbore cartridge is like spitting through a thin straw. You can't blow too hard/fast because you'll pop your ears and eyes out. So that's the equivalent of using a slow burning powder so the energy doesn't build up too fast and cause too much pressure.
A underbore cartridge is like spitting through a very big in diameter straw. You can blow as hard and fast as you want because you need to build up pressure as fast as possible in a short time to make the bigger spitball fly fast. So it's the same as using a faster burning powder that build us pressure fast.
With most cartridges you want to use slightly faster powders with the lighter bullets compared to heavy bullets.
For example... 243 Winchester, with 105+ gr bullets is best to use slower powders between H-4350 and Retumbo burn rates.. I find H-4350 a bit too fast for 105+ gr bullets in the 243win, but many use 4350 and it works like a dream for them, while I use H-4831, IMR-7828, H-1000, RL-25/26, Retumbo burn rates.
Now, if you want to use 55-58 gr bullets in the 243win, you'll want to stick with powders in the Varget burn rate. This is again akin to the straw/spitball comparison.
Take the same size straw and shove a short light piece of paper down the straw and you'll be able to blow faster/harder to get it to shoot as compared to a long heavy piece of paper in the same straw. For the long heavy straw projectile you'll have to blow slower so you don't build too much pressure inside your mouth and blow your eardrums.
I hope you somewhat get my idea. Kinda silly, but it makes sense to me.
So if a powder is not in the reloading manual but is in the same burn rate as the ones listed that means it should be good to go, only the manual didn't test it. But just because 2 powders have the same burn rate doesn't mean they will produce the same energy with the same amount of powder charge weight. So if you can't find data for a specific powder, it's best to avoid it to be on the safe side.