Hi,
I have the following table, and I want to display the value of column c based on the name in column A. When I use the LOOKUP statement if gives me true or false. How do I go about getting the actual value to display in column c, please?
Date
Votes
1 comment
-
Hello,
What is an example of the LOOKUP formula you are using? Are you using GROUP and GROUPBY? In your picture, there are two of the same name in column A, LOOKUP will return the first match and display it based on the property type - Number, Text, Date, etc. If you are using GROUPBY, then you can select how to handle the grouped values.The default is SUM, so you can select FIRST, JOIN, LAST, etc if you have text for the display.
Our docs have examples:
https://support.klipfolio.com/hc/en-us/articles/216182777-LOOKUP-video-
https://support.klipfolio.com/hc/en-us/articles/215547998-GROUP-GROUPBY-and-COUNTDISTINCT-video-
Thanks
Meggan
Please sign in to leave a comment.