topic How would be VBScritp for VLOOKUP function by Field Calculator ? in ArcGIS Analyse Questions https://community.esri.com/t5/arcgis-analyse-questions/how-would-be-vbscritp-for-vlookup-function-by/m-p/826434#M84 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P>I would like to know if it's possible to use VLOOKUP formula by Field Calculator.</P><P>I need to fill some informations according to data in attribule table. To exemplify, i'm using this table below.&nbsp;&nbsp;&nbsp; </P><P></P><TABLE><TBODY><TR><TD></TD><TD><SPAN style="color: #3d3d3d;">column A</SPAN></TD><TD><SPAN style="color: #3d3d3d;">column B</SPAN></TD><TD><SPAN style="color: #3d3d3d;">column C</SPAN></TD><TD><SPAN style="color: #3d3d3d;">column D</SPAN></TD></TR><TR><TD></TD><TD><SPAN style="color: #3d3d3d;"><STRONG>COTM</STRONG></SPAN></TD><TD><SPAN style="color: #3d3d3d;"><STRONG>OTTOM</STRONG></SPAN></TD><TD><SPAN style="color: #3d3d3d;"><STRONG>COTJ</STRONG></SPAN></TD><TD><SPAN style="color: #3d3d3d;"><STRONG>OTTOJ</STRONG></SPAN></TD></TR><TR><TD><SPAN style="color: #3d3d3d;">row 3</SPAN></TD><TD><SPAN style="color: #3d3d3d;">A</SPAN>D2</TD><TD>88ab</TD><TD>AD2</TD><TD></TD></TR><TR><TD>row 4</TD><TD>DF3</TD><TD>87ab</TD><TD>AD2</TD><TD></TD></TR><TR><TD>row 5</TD><TD>TR5</TD><TD>86ab</TD><TD>TR5</TD><TD></TD></TR><TR><TD>row 6</TD><TD>GH4</TD><TD>85ab</TD><TD>FS2</TD><TD></TD></TR><TR><TD>row 7</TD><TD>FS2</TD><TD>84ab</TD><TD>TR5</TD><TD></TD></TR></TBODY></TABLE><P><SPAN style="line-height: 1.5;">If were to do the calculation by Excel, the operation would be simple, like: </SPAN><SPAN style="line-height: 1.5;">D3 = VLOOKUP (C3;A:B;2;FALSE)</SPAN></P><P><SPAN style="line-height: 1.5;">How would be VBAcript for VLOOKUP function by Field Calculator?</SPAN><SPAN style="line-height: 1.5;">If someone know how to help me, I appreciate.</SPAN></P><P><SPAN style="line-height: 1.5;">Gabriela</SPAN></P></BODY></HTML> Thu, 26 Feb 2015 15:49:11 GMT GabrielaCorrea 2015-02-26T15:49:11Z How would be VBScritp for VLOOKUP function by Field Calculator ? https://community.esri.com/t5/arcgis-analyse-questions/how-would-be-vbscritp-for-vlookup-function-by/m-p/826434#M84 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P>I would like to know if it's possible to use VLOOKUP formula by Field Calculator.</P><P>I need to fill some informations according to data in attribule table. To exemplify, i'm using this table below.&nbsp;&nbsp;&nbsp; </P><P></P><TABLE><TBODY><TR><TD></TD><TD><SPAN style="color: #3d3d3d;">column A</SPAN></TD><TD><SPAN style="color: #3d3d3d;">column B</SPAN></TD><TD><SPAN style="color: #3d3d3d;">column C</SPAN></TD><TD><SPAN style="color: #3d3d3d;">column D</SPAN></TD></TR><TR><TD></TD><TD><SPAN style="color: #3d3d3d;"><STRONG>COTM</STRONG></SPAN></TD><TD><SPAN style="color: #3d3d3d;"><STRONG>OTTOM</STRONG></SPAN></TD><TD><SPAN style="color: #3d3d3d;"><STRONG>COTJ</STRONG></SPAN></TD><TD><SPAN style="color: #3d3d3d;"><STRONG>OTTOJ</STRONG></SPAN></TD></TR><TR><TD><SPAN style="color: #3d3d3d;">row 3</SPAN></TD><TD><SPAN style="color: #3d3d3d;">A</SPAN>D2</TD><TD>88ab</TD><TD>AD2</TD><TD></TD></TR><TR><TD>row 4</TD><TD>DF3</TD><TD>87ab</TD><TD>AD2</TD><TD></TD></TR><TR><TD>row 5</TD><TD>TR5</TD><TD>86ab</TD><TD>TR5</TD><TD></TD></TR><TR><TD>row 6</TD><TD>GH4</TD><TD>85ab</TD><TD>FS2</TD><TD></TD></TR><TR><TD>row 7</TD><TD>FS2</TD><TD>84ab</TD><TD>TR5</TD><TD></TD></TR></TBODY></TABLE><P><SPAN style="line-height: 1.5;">If were to do the calculation by Excel, the operation would be simple, like: </SPAN><SPAN style="line-height: 1.5;">D3 = VLOOKUP (C3;A:B;2;FALSE)</SPAN></P><P><SPAN style="line-height: 1.5;">How would be VBAcript for VLOOKUP function by Field Calculator?</SPAN><SPAN style="line-height: 1.5;">If someone know how to help me, I appreciate.</SPAN></P><P><SPAN style="line-height: 1.5;">Gabriela</SPAN></P></BODY></HTML> Thu, 26 Feb 2015 15:49:11 GMT https://community.esri.com/t5/arcgis-analyse-questions/how-would-be-vbscritp-for-vlookup-function-by/m-p/826434#M84 GabrielaCorrea 2015-02-26T15:49:11Z Re: How would be VBScritp for VLOOKUP function by Field Calculator ? https://community.esri.com/t5/arcgis-analyse-questions/how-would-be-vbscritp-for-vlookup-function-by/m-p/826435#M85 <HTML><HEAD></HEAD><BODY><P>Does it have to be in the Field Calculator? If not you could summarize the table based on field COTM and taking the first of field OTTOM, then join the output table to this table on the field COTJ and fill field OTTOJ with the values from the joined field OTTOM.</P></BODY></HTML> Thu, 26 Feb 2015 17:10:31 GMT https://community.esri.com/t5/arcgis-analyse-questions/how-would-be-vbscritp-for-vlookup-function-by/m-p/826435#M85 XanderBakker 2015-02-26T17:10:31Z Re: How would be VBScritp for VLOOKUP function by Field Calculator ? https://community.esri.com/t5/arcgis-analyse-questions/how-would-be-vbscritp-for-vlookup-function-by/m-p/826436#M86 <HTML><HEAD></HEAD><BODY><P>Indeed. It's a great solution.</P><P>I had thought to use VLOOKUP function 'cause in fact I have to do this process more than once and with different variables in the same atttibutes table, but I can do that with summarize... perhaps it's take more time, but it's possible.</P><P>Thank you!</P></BODY></HTML> Thu, 26 Feb 2015 20:54:36 GMT https://community.esri.com/t5/arcgis-analyse-questions/how-would-be-vbscritp-for-vlookup-function-by/m-p/826436#M86 GabrielaCorrea 2015-02-26T20:54:36Z Re: How would be VBScritp for VLOOKUP function by Field Calculator ? https://community.esri.com/t5/arcgis-analyse-questions/how-would-be-vbscritp-for-vlookup-function-by/m-p/826437#M87 <HTML><HEAD></HEAD><BODY><P>If you have to do it multiple times, you could consider using some python code (to do this automatically). If you need some help with it, let me know.</P></BODY></HTML> Thu, 26 Feb 2015 21:38:56 GMT https://community.esri.com/t5/arcgis-analyse-questions/how-would-be-vbscritp-for-vlookup-function-by/m-p/826437#M87 XanderBakker 2015-02-26T21:38:56Z