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?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!