Hello All,
I am trying to use an excel formula that calculates for me the match of two columns and show me the results.
If I want to calculate one column I am using this formula: =IF(ISERROR(VLOOKUP(E18,A18:A22,1,0))=TRUE,"",E18).
It's working really good, but it's seems impossible if i want to integrate a new column.
Can some one help me please? Below I am posting an example:
<style><!--table {mso-displayed-decimal-separator:"\,"; mso-displayed-thousand-separator:"\.";}@page {margin:.75in .7in .75in .7in; mso-header-margin:.3in; mso-footer-margin:.3in;}td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignoreadding; color:black; font-size:12.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;}--></style>[TABLE="width: 696"]
<!--StartFragment--> <colgroup><col width="87" span="8" style="width:65pt"> </colgroup><tbody>[TR]
[TD="width: 87"][TABLE="width: 435"]
<colgroup><col span="5"></colgroup><tbody>[TR]
[TD="colspan: 2"] Table array 1[/TD]
[TD="colspan: 2"] Table array 2[/TD]
[TD]Lookup values[/TD]
[/TR]
[TR]
[TD]subject 1[/TD]
[TD][/TD]
[TD]subject a[/TD]
[TD][/TD]
[TD]subject n[/TD]
[/TR]
[TR]
[TD]subject 2[/TD]
[TD][/TD]
[TD]subcjet b[/TD]
[TD][/TD]
[TD]subject 1[/TD]
[/TR]
[TR]
[TD]subject 3[/TD]
[TD][/TD]
[TD]subject c[/TD]
[TD][/TD]
[TD]subject e[/TD]
[/TR]
[TR]
[TD]subject 4[/TD]
[TD][/TD]
[TD]subject d[/TD]
[TD][/TD]
[TD]subject q[/TD]
[/TR]
[TR]
[TD]subject 5
[/TD]
[TD][/TD]
[TD]subject e[/TD]
[TD][/TD]
[TD]subject 2[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="width: 87"]
[/TD]
[TD="width: 87"][/TD]
[TD="width: 87"][/TD]
[TD="width: 87"][/TD]
[TD="width: 87"][/TD]
[TD="width: 87"][/TD]
[TD="width: 87"][/TD]
[/TR]
</tbody>[/TABLE]
Thank you in advance.
I am trying to use an excel formula that calculates for me the match of two columns and show me the results.
If I want to calculate one column I am using this formula: =IF(ISERROR(VLOOKUP(E18,A18:A22,1,0))=TRUE,"",E18).
It's working really good, but it's seems impossible if i want to integrate a new column.
Can some one help me please? Below I am posting an example:
<style><!--table {mso-displayed-decimal-separator:"\,"; mso-displayed-thousand-separator:"\.";}@page {margin:.75in .7in .75in .7in; mso-header-margin:.3in; mso-footer-margin:.3in;}td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignoreadding; color:black; font-size:12.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;}--></style>[TABLE="width: 696"]
<!--StartFragment--> <colgroup><col width="87" span="8" style="width:65pt"> </colgroup><tbody>[TR]
[TD="width: 87"][TABLE="width: 435"]
<colgroup><col span="5"></colgroup><tbody>[TR]
[TD="colspan: 2"] Table array 1[/TD]
[TD="colspan: 2"] Table array 2[/TD]
[TD]Lookup values[/TD]
[/TR]
[TR]
[TD]subject 1[/TD]
[TD][/TD]
[TD]subject a[/TD]
[TD][/TD]
[TD]subject n[/TD]
[/TR]
[TR]
[TD]subject 2[/TD]
[TD][/TD]
[TD]subcjet b[/TD]
[TD][/TD]
[TD]subject 1[/TD]
[/TR]
[TR]
[TD]subject 3[/TD]
[TD][/TD]
[TD]subject c[/TD]
[TD][/TD]
[TD]subject e[/TD]
[/TR]
[TR]
[TD]subject 4[/TD]
[TD][/TD]
[TD]subject d[/TD]
[TD][/TD]
[TD]subject q[/TD]
[/TR]
[TR]
[TD]subject 5
[/TD]
[TD][/TD]
[TD]subject e[/TD]
[TD][/TD]
[TD]subject 2[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="width: 87"]
[/TD]
[TD="width: 87"][/TD]
[TD="width: 87"][/TD]
[TD="width: 87"][/TD]
[TD="width: 87"][/TD]
[TD="width: 87"][/TD]
[TD="width: 87"][/TD]
[/TR]
</tbody>[/TABLE]
Thank you in advance.