Forum

Notifications
Clear all

Extracting values from another file by searching two arrays

5 Posts
2 Users
0 Reactions
60 Views
(@smssayeed)
Posts: 3
Active Member
Topic starter
 

I have two columns (with country code and HS code) and I have to select the exact value (from the green water footprint or crop GWF sheet) of the country code and the HS code from another sheet.
I am attaching the sheet. Could you recommend what's the best way to do it?

 

 
 
Posted : 07/04/2023 10:07 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Sayeed,

Your file didn't get attached. You need to click the yellow 'start upload' button after selecting your file and then wait for the grey check mark beside the file size before clicking 'submit'.

Mynda

 
Posted : 07/04/2023 6:34 pm
(@smssayeed)
Posts: 3
Active Member
Topic starter
 

Even reducing file size, it keeps getting error for exceeding size limit

 

 
 
Posted : 08/04/2023 4:10 am
(@smssayeed)
Posts: 3
Active Member
Topic starter
 

Uploaded the file.

 
 
Posted : 08/04/2023 4:16 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Sayeed,

Your question isn't clear, sorry. I don't see anything called 'green water footprint' and I'm not following the flow of data from where it is to where you want it to go.

Please provide a small sample file that clearly illustrates your desired result.

Mynda

 
Posted : 08/04/2023 10:40 pm
Share: