Help with Dlookup needed

[David_Skov]

I have this function:

=DLookUp("[LYFY]";"DVH_krydstabel";"[Market] = DAGLIGVAREHANDLEN EX. COOP")

But it gives me an error (#error)

DVH_krydstabel has these coloumns:

Market, SegmentID, DMLY, DMTY, LYFY, YTDLY, YTDTY

The Dlookup function should give me the value of [LYFY] in the tabel 'DVH_krydstabel' where [Market] = 'DAGLIGVAREHANDLEN EX. COOP' and SegmentID equal the current Segment shown in the report.

Tx

 

[Andrew Fergus]

Hi David

Is this post related to this post?

If we can answer the other post then I think this one might be redundant.

Please correct me if I am wrong.

Andrew.

 

[Norie]

[Market] = 'DAGLIGVAREHANDLEN EX. COOP'

David

I think you may have identified the problem yourself. In the DLOOKUP you have omitted the single quotation marks (').

Try

=DLookUp("[LYFY]";"DVH_krydstabel";"[Market] = 'DAGLIGVAREHANDLEN EX. COOP'")