topic identify unmatched data in QlikView https://community.qlik.com/t5/QlikView/identify-unmatched-data/m-p/1250763#M853027 <HTML><HEAD></HEAD><BODY><P>hi all,</P><P></P><P>how to find unmatched data identifying in two excel sheets?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z identify unmatched data https://community.qlik.com/t5/QlikView/identify-unmatched-data/m-p/1250763#M853027 <HTML><HEAD></HEAD><BODY><P>hi all,</P><P></P><P>how to find unmatched data identifying in two excel sheets?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/identify-unmatched-data/m-p/1250763#M853027 2020-11-25T16:16:04Z Re: identify unmatched data https://community.qlik.com/t5/QlikView/identify-unmatched-data/m-p/1250764#M853028 <HTML><HEAD></HEAD><BODY><P>There is<STRONG> vLookup()</STRONG> function in Excel it will help to you for comparison any type of data in 2 columns..</P><P></P><P><SPAN style="color: #454545; font-family: 'Courier new'; font-size: 14px; font-weight: 600; background-color: #f5f5f5;"> syntax of is VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])</SPAN></P><P><SPAN style="color: #454545; font-family: 'Courier new'; font-size: 14px; font-weight: 600; background-color: #f5f5f5;"><BR /></SPAN></P><P><SPAN style="color: #454545; font-family: 'Courier new'; font-size: 14px; font-weight: 600; background-color: #f5f5f5;"><A href="https://www.ablebits.com/office-addins-blog/2014/07/17/excel-vlookup-tutorial-beginner/" title="https://www.ablebits.com/office-addins-blog/2014/07/17/excel-vlookup-tutorial-beginner/">https://www.ablebits.com/office-addins-blog/2014/07/17/excel-vlookup-tutorial-beginner/</A></SPAN></P><P></P><P>or else if you share both the excel sheets with small amount of sample data we will help to you</P><P></P><P><SPAN style="font-size: 13.3333px;">if you got the the solution</SPAN>,Please close the thread by clicking <STRONG>correct Answer </STRONG></P></BODY></HTML> Thu, 23 Feb 2017 13:49:33 GMT https://community.qlik.com/t5/QlikView/identify-unmatched-data/m-p/1250764#M853028 ramasaisaksoft 2017-02-23T13:49:33Z