Referencing a Report in a VLOOKUP


I've read numerous times that we can reference a VLOOKUP in a sheet from a Report,

I'm trying to figure out how

=IF(ISERROR(VLOOKUP(Address28, {Customer ID Consol Report}Primary1:[Customer ID]1)))

Any assistance?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!