Possible match and return certain values

Np72 · Mar 4, 2011

I have this data in 4 sheets

<TABLE style="WIDTH: 473pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=630 border=0 x:str><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 2998" width=82><COL style="WIDTH: 74pt; mso-width-source: userset; mso-width-alt: 3620" width=99><COL style="WIDTH: 68pt; mso-width-source: userset; mso-width-alt: 3328" width=91><COL style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 3876" width=106><COL style="WIDTH: 93pt; mso-width-source: userset; mso-width-alt: 4534" width=124><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=64 height=17>A</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 62pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=82>B</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 74pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=99>C</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 68pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=91>D</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 80pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=106>E</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 93pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=124>F</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=64>G</TD></TR><TR style="HEIGHT: 22.5pt" height=30><TD class=xl22 dir=ltr style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 22.5pt; BACKGROUND-COLOR: transparent" width=64 height=30></TD><TD class=xl23 dir=ltr style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 62pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=82>SumOfHoldings</TD><TD class=xl24 dir=ltr style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 74pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=99>Percentage_Issued_</TD><TD class=xl24 dir=ltr style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 68pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=91>SharesOut</TD><TD class=xl23 dir=ltr style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 80pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=106>SecName</TD><TD class=xl23 dir=ltr style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 93pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=124>SecIssue</TD><TD class=xl24 dir=ltr style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=64>CountryISO</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl25 dir=ltr style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: yellow" width=64 height=17>PAM SA</TD><TD class=xl26 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: yellow" x:num="-770000">-770,000</TD><TD class=xl27 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: yellow" x:num="-0.81331322344211232">-0.813313%</TD><TD class=xl28 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: yellow">94,674,472.00</TD><TD class=xl29 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: yellow">UBISOFT ENTERTAINMENT</TD><TD class=xl29 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: yellow">EUR0.08</TD><TD class=xl29 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: yellow">FRA</TD></TR></TBODY></TABLE>

Is there any way in sheet 5 (data sheet) I can lookup the country and return the SecName and if the Percentage issued is greater 0.2%

Thanks

schielrn · Mar 4, 2011

Assuming FRA is only there once and I'm not positive I understand teh 2nd part, you want to only return the SecName if % issued is greater than .2%? Or you want to return both SeName and % issued is greater than .2% or is not?

I'm a little lost on what you want returned?

Np72 · Mar 4, 2011

Hi FRA appears on the report a number of times. I also want to capture ESP & and PRT. returning the sec name and if it is equal greater than -0.20% I thought about a looping macro to go through all 4 sheets

The returned should look like this

Ubisoft -0.813313 FRA

And alike if there are any stocks that have ESP and PRT and are greater than or equal to -0.20

schielrn · Mar 4, 2011

It proabbly will take a macro to do this, but unfortunately I don't have time to design a macro for it, but how is -.813313% > -.2%

shaunroberts10 · Mar 7, 2011

Entrega de anillo de compromiso | Momentos VoloPapilio.

****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 12">****** name="Originator" content="Microsoft Word 12"><link rel="File-List" href="file:///C:%5CUsers%5CDC-12%28%7E1%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"><link rel="themeData" href="file:///C:%5CUsers%5CDC-12%28%7E1%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx"><link rel="colorSchemeMapping" href="file:///C:%5CUsers%5CDC-12%28%7E1%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml"><style> <!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:0; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature:-1610611985 1107304683 0 0 415 0;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-520092929 1073786111 9 0 415 0;} @font-face {font-family:"Myraid pro"; panose-1:0 0 0 0 0 0 0 0 0 0; mso-font-alt:"Times New Roman"; mso-font-charset:0; mso-generic-font-family:roman; mso-font-format

ther; mso-font-pitch:auto; mso-font-signature:0 0 0 0 0 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-ansi-language:ES-MX; mso-fareast-language:ZH-CN;} a:link, span.MsoHyperlink {mso-style-priority:99; color:blue; text-decoration:underline; text-underline:single;} a:visited, span.MsoHyperlinkFollowed {mso-style-noshow:yes; mso-style-priority:99; color

urple; mso-themecolor:followedhyperlink; text-decoration:underline; text-underline:single;} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; font-size:10.0pt; mso-ansi-font-size:10.0pt; mso-bidi-font-size:10.0pt; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-ansi-language:ES-MX;} @page WordSection1 {size:8.5in 11.0in; margin:70.85pt 85.05pt 70.85pt 85.05pt; mso-header-margin:35.4pt; mso-footer-margin:35.4pt; mso-paper-source:0;} div.WordSection1 {page:WordSection1;} --> </style><o></o> Anillo de Compromiso.
<o

> </o

>
El símbolo de tu amor: El anillo de compromiso
<o

> </o

>
[FONT=&quot]La entrega del anillo de compromiso es uno de los retos más difíciles para quien ha decidido tomar el importante compromiso del matrimonio para su vida.<o

></o

>[/FONT]
<o

> </o

>
La forma de entregarlo es quizá más importante que el anillo mismo. Pues no solo habla de un esfuerzo económico sino de tiempo, creatividad y dedicación.
<o

> </o

>
He participado en la entrega de decenas de anillos y me doy cuenta que las posibilidades son infinitas, pero también descubrí que hay 3 elementos que no deben faltar: sorprender, consentir y conmover.
<o

> </o

>
Este momento es sumamente especial y debe ser tan significativo que perdure en el recuerdo de ambos por muchísimo tiempo, que incluso sea un suceso digno de contárselo a sus hijos o nietos. Por eso es muy importante planearlo con anticipación para que impactes y sorprendas a tu pareja.
<o

> </o

>
El anillo de compromiso, tradicionalmente, significa que la persona que lo lleva puesto está enamorada y comprometida con la persona que se lo entrego o en otras palabras “tomado”. Este tiene origen en la historia de los egipcios que tenían la creencia que debería llevarse puesto en el dedo del anillo, donde hasta el día de hoy se acostumbra ponerse, porque a través de ese dedo pasa una vena que envía la sangre al corazón. Mientras que los romanos hacían el anillo de compromiso de hierro para simbolizar fuerza y eternidad.
<o

> </o

>
Hoy en día, el anillo de compromiso simboliza lo mismo que es: amor, compromiso y una boda para la feliz pareja.
<o

> </o

>
<o

> </o

>
http://www.volopapilio.com.mx/Entrega-de-anillo-de-compromiso.htm

Possible match and return certain values

Np72

Board Regular

Excel Facts

schielrn

Well-known Member

Np72

Board Regular

schielrn

Well-known Member

shaunroberts10

New Member

Similar threads

Forum statistics

Share this page

Possible match and return certain values

Np72

Board Regular

Excel Facts

schielrn

Well-known Member

Np72

Board Regular

schielrn

Well-known Member

shaunroberts10

New Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock