We propose a scheme to measure the frequency-resolved local particle and hole spectra of any optical lattice-confined system of correlated ultracold atoms that offers single-site addressing and imaging, which is now an experimental reality. Combining perturbation theory and time-dependent density matrix renormalization group simulations, we quantitatively test and validate this approach of lattice-assisted spectroscopy on several one-dimensional example systems, such as the superfluid and Mott insulator, with and without a parabolic trap, and finally on edge states of the bosonic Su-Schrieffer-Heeger model. We highlight extensions of our basic scheme to obtain an even wider variety of interesting and important frequency resolved spectra.