---
title: "Querying Comments"
description: "You can use LUCANET formulas to query comments in Lucanet (e.g. for values in the general ledger, in subledgers or in schedules) and read them in to MS Excel."
source_url: https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/excel-integration/cfp-add-in/querying-data/querying-comments
language: en
last_updated: 2023-08-16
---
# Querying Comments

## Overview

You can use LUCANET formulas to query comments in Lucanet (e.g. for values in the general ledger, in subledgers or in schedules) and read them in to MS Excel.

## Structure of the LUCANET Formulas

To read in comments from Lucanet to MS Excel, the LUCANET formula must be set up as follows:

```
=LN.COMMENT("Abbreviation","Data level","Adjustment level","Organization element",
"Account or Item","Periodicity","StartDate",["EndDate"],["Transaction type"],
["Display currency"],["Transaction currency"],["Partner/partner group"])

```

## Parameters

All parameters must be specified just as described in [Querying Values](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/excel-integration/cfp-add-in/querying-data/querying-values.md). The formula can be added with [optional parameters](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/excel-integration/cfp-add-in/querying-data/querying-values.md#optpara).