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
-
Unfortunately reports cannot be used as a source for cross sheet references. It would be great if we could though. Feel free to Submit a Product Enhancement Request when you are able.
I am curious if you are able to provide references to where you read that though.
-
@Paul Newcome Has anything changed on the above? I would like to VLOOKUP to a Report, but am getting errors. This message is several years old so I wanted to validate.
-
@RBrewster Unfortunately the only thing that is changed is how we submit product enhancement requests.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!