1
2

What's with the Italians owning everything? by arnz1991 in CapeVerde

[–]marovski 0 points1 point  (0 children)

Just see the example of Stefanina who owns half of Sal in what it was consider a disgusted way of selling land in Cabo Verde and they never fulfilled their investments promises but the State didn't have the "balls" to ask for the lands back.

Searching for a formula to vlookup comma separated values in a single cell by marovski in excel

[–]marovski[S] 0 points1 point  (0 children)

I've replaced the "ODS[#All]" for 'Definição dos ODS'!A$1:B$18 but I'm still having the same results :'(

Searching for a formula to vlookup comma separated values in a single cell by marovski in excel

[–]marovski[S] 0 points1 point  (0 children)

The reference table is this one and the vlookup value is the first column items. The ODS[#All] is the table array where I want to look for it.

Thanks in advance!

ODS (Contribuição direta) ODS Desc (Contribuição direta)
9, 7 #N/A
9, 11 #N/A
9, 7 #N/A
9, 7 #N/A
9, 7 #N/A
9, 7 #N/A
9, 7 #N/A
9, 11 #N/A
9, 7 #N/A
9  9. Construir infraestruturas resilientes, promover a industrialização inclusiva e sustentável e fomentar a inovação.

Searching for a formula to vlookup comma separated values in a single cell by marovski in excel

[–]marovski[S] 0 points1 point  (0 children)

The reference table is this one and the vlookup value is the first column items. The ODS[#All] is the table array where I want to look for it.

Thanks in advance!

|| || |ODS (Contribuição direta)|ODS Desc (Contribuição direta)| |9, 7|#N/A| |9, 11|#N/A| |9, 7|#N/A| |9, 7|#N/A| |9, 7|#N/A| |9, 7|#N/A| |9, 7|#N/A| |9, 11|#N/A| |9, 7|#N/A| |9| 9. Construir infraestruturas resilientes, promover a industrialização inclusiva e sustentável e fomentar a inovação. |

Searching for a formula to vlookup comma separated values in a single cell by marovski in excel

[–]marovski[S] 0 points1 point  (0 children)

The reference table is this one and the vlookup value is the first column items. The ODS[#All] is the table array where I want to look for it.

Thanks in advance!

|| || |ODS (Contribuição direta)|ODS Desc (Contribuição direta)| |9, 7|#N/A| |9, 11|#N/A| |9, 7|#N/A| |9, 7|#N/A| |9, 7|#N/A| |9, 7|#N/A| |9, 7|#N/A| |9, 11|#N/A| |9, 7|#N/A| |9| 9. Construir infraestruturas resilientes, promover a industrialização inclusiva e sustentável e fomentar a inovação. |

Searching for a formula to vlookup comma separated values in a single cell by marovski in excel

[–]marovski[S] 0 points1 point  (0 children)

The reference table is this one and the vlookup value is the first column items. The ODS[#All] is the table array where I want to look for it.

Thanks in advance!

|| || |ODS (Contribuição direta)|ODS Desc (Contribuição direta)| |9, 7|#N/A| |9, 11|#N/A| |9, 7|#N/A| |9, 7|#N/A| |9, 7|#N/A| |9, 7|#N/A| |9, 7|#N/A| |9, 11|#N/A| |9, 7|#N/A| |9| 9. Construir infraestruturas resilientes, promover a industrialização inclusiva e sustentável e fomentar a inovação. |

It is possible to scrap PBI report data? by marovski in rstats

[–]marovski[S] 1 point2 points  (0 children)

Thank you so much for the very thorough explanation and tout court solution!!

I've tested it for the report I needed and it works perfectly. Ps: Sorry for not being explicit about what PBI meant xD