Pull data using the name associated with a value from an external sheet

[Kal_Lam]

Welcome to the community, @ak123! Maybe these posts discussed previously should be able to help you solve your issue:

Managing skip logic with pulled data

@fjiva, maybe this workaround should solve your issue: In the survey tab of your XLSForm: [Image 1] The CSV file: [Image 2] Data entry screen as seen in Enketo: when nothing is entered [Image 3] Data entry screen as seen in Enketo: when a book code within a range is entered [Image 4] Data entry screen as seen in Enketo: when a book code out of the range is entered [Image 5] Reference XLSForm: Pull Data (Skip).xls (28.5 KB) Reference CSV file: Codes.csv (137 Bytes) Note: If…

And this one too …

Pull Data with If Condition from 2 external Files

Hi @stephanealoo Thanks for updating However i could able to the same , just sharing in case any one from community need it if(${work} = ‘1’,pulldata(‘recoveryupload.csv’, ‘branch’, ‘memecode_key’, ${ecode}),pulldata(‘odupload.csv’, ‘branch’, ‘memecode_key’, ${ecode_x})) Above formula was used to pull data from two different external file basis pull method Please check and guide in case i missed something ,if any type name label required relevant appearance calculation read_only s…