Skip to main content
Answer

Can you reference a data file in a formula?

  • October 27, 2021
  • 4 replies
  • 27 views

Eric S102

I'd like to upload an excel file with a table of data so I can have data driven objects. Can I somehow reference the data file(s) with rows and columns and use them in formulas etc?

Best answer by Katrina V

Hi Eric

Thanks for posting in the Lucidchart Community! This is possible with the =LOOKUP function. I recommend reviewing our documentation for this formula/function.

Please let me know if you have any other questions.

Comments

Katrina V
  • Lucid support team
  • Answer
  • October 29, 2021

Hi Eric

Thanks for posting in the Lucidchart Community! This is possible with the =LOOKUP function. I recommend reviewing our documentation for this formula/function.

Please let me know if you have any other questions.


Eric S102
  • Author
  • October 29, 2021

That's great. Thank you. It might be nice if there werre some samples and help documents on how to do this around the training on using data files. Id imagine new users would understand what's possible with data files if this was mentioned along with basic drag and drop functionality.


Katrina V
  • Lucid support team
  • October 29, 2021

Hi Eric

Thanks for the suggestion! We do have a Help Center article on formulas as well as some other articles related to data in our Help Center. 

I'll pass this feedback on to our customer experience team.

 


Micah
Forum|alt.badge.img+20
  • Lucid community team
  • May 6, 2024

Hi! I’m Micah from Lucid’s community team. 👋 I thought you, and any others who might come across this topic in the future, might be interested in Lucid’s Data Trusted User Group. This group is made up of knowledgeable users who regularly analyze and visualize data in their work. As part of this group, you’ll have the opportunity to connect directly with Lucid’s product team, gain early access to beta features, and share insights about your needs, shaping the future of Lucid’s data solutions 🎉 You can learn more and request to join here. Thanks!