# \#vlookup **URL:** https://forum.uipath.com/tag/vlookup/2447.md [Latest](https://forum.uipath.com/latest.md) · [Categories](https://forum.uipath.com/categories.md) · [Tags](https://forum.uipath.com/tags.md) --- ## [I am trapped in look up data table](https://forum.uipath.com/t/i-am-trapped-in-look-up-data-table/5726144)
**Author:** [@kjy03171](https://forum.uipath.com/u/kjy03171)\ **Replies:** 3\ **Last updated:** [March 5, 2026, 9:30am UTC](https://forum.uipath.com/t/i-am-trapped-in-look-up-data-table/5726144 "2026-03-05T09:30:15Z")
I want to search for today’s date from excel file and return the cell right next to it. But I feel it difficult to go through because all that I find in youtube is run by old version. Can anyone help me figure out with l… --- ## [Cannot use VLOOKUP activity in package version2.23.2](https://forum.uipath.com/t/cannot-use-vlookup-activity-in-package-version2-23-2/736327)
**Author:** [@FINNNNNNNN](https://forum.uipath.com/u/FINNNNNNNN)\ **Replies:** 2\ **Last updated:** [May 14, 2024, 7:42am UTC](https://forum.uipath.com/t/cannot-use-vlookup-activity-in-package-version2-23-2/736327 "2024-05-14T07:42:09Z")
Dear Forum, I encountered an issue with the “VLookup: TypeConverter cannot convert from System.String” error. Upon updating the Excel package version to v2.22.3, the problem was resolved, and the functionality worked as… --- ## [VLookup between two different Excel where column could contain null values](https://forum.uipath.com/t/vlookup-between-two-different-excel-where-column-could-contain-null-values/728136)
**Author:** [@rishiathawale](https://forum.uipath.com/u/rishiathawale)\ **Replies:** 4\ **Last updated:** [March 20, 2024, 8:51am UTC](https://forum.uipath.com/t/vlookup-between-two-different-excel-where-column-could-contain-null-values/728136 "2024-03-20T08:51:13Z")
Hi All, I am trying to apply VLookup between 2 different excel where column could have null values in it. Below is the sample data Input - DT1 Input - DT2 Output Below is the query I have written but it is… --- ## [Error while using vLookUp activity in StudioX](https://forum.uipath.com/t/error-while-using-vlookup-activity-in-studiox/717175)
**Author:** [@leyin\_meng](https://forum.uipath.com/u/leyin_meng)\ **Replies:** 15\ **Last updated:** [February 7, 2024, 4:14pm UTC](https://forum.uipath.com/t/error-while-using-vlookup-activity-in-studiox/717175 "2024-02-07T16:14:05Z")
Hello, I have been receiving error : “TypeConverter cannot convert from System.String” when I use vLookUp activity in StudioX. I have tried methods shown in YouTube or previously discussed in the forum, I still cannot r… --- ## [Use Vlookup between two diferent excel files](https://forum.uipath.com/t/use-vlookup-between-two-diferent-excel-files/712831)
**Author:** [@johan.montalvo](https://forum.uipath.com/u/johan.montalvo)\ **Replies:** 4\ **Last updated:** [January 17, 2024, 10:28pm UTC](https://forum.uipath.com/t/use-vlookup-between-two-diferent-excel-files/712831 "2024-01-17T22:28:55Z")
Hi guys. I hope you’re well I want to use vlookup between two diferents excel files ( ventas.xlsx, expense.xlsx) to extract a column called “gastos\_operacion” from the second one towards the first. The pivot column is “… --- ## [LinQ Query for VlookUp Need Help](https://forum.uipath.com/t/linq-query-for-vlookup-need-help/707952)
**Author:** [@Ramesh\_Kola1](https://forum.uipath.com/u/Ramesh_Kola1)\ **Replies:** 2\ **Last updated:** [December 21, 2023, 11:45am UTC](https://forum.uipath.com/t/linq-query-for-vlookup-need-help/707952 "2023-12-21T11:45:41Z")
I have 2 Excels, in FilterStatementofAccount I have Column Ar Amount, and I have another Excel name with FilterOverallClaims, I need to do Vlookup to Ar Amount from FilterStatementofAccount.xlsx to FilterOverallClaims.xl… --- ## [Logic or LINQ required for below Question](https://forum.uipath.com/t/logic-or-linq-required-for-below-question/701556)
**Author:** [@Vicky\_K](https://forum.uipath.com/u/Vicky_K)\ **Replies:** 6\ **Last updated:** [November 22, 2023, 11:01am UTC](https://forum.uipath.com/t/logic-or-linq-required-for-below-question/701556 "2023-11-22T11:01:20Z")
Hi All, Data 1 we received as CSV file format it is like data table and having 1L rows data. like database And we receive one input file we have coulmn ID, from that input file we need to compare CSV file coulmn “ID”… --- ## [Excel Lookup with a word contains dot (.) in the middle](https://forum.uipath.com/t/excel-lookup-with-a-word-contains-dot-in-the-middle/577552)
**Author:** [@ozlem.ciftci](https://forum.uipath.com/u/ozlem.ciftci)\ **Replies:** 2\ **Last updated:** [September 7, 2023, 8:53am UTC](https://forum.uipath.com/t/excel-lookup-with-a-word-contains-dot-in-the-middle/577552 "2023-09-07T08:53:57Z")
Hi there, I have an excel that contains two sheets, one for reference and other one is the main one. Reference one has two columns those columns is like key-value pair ones. What i doing here is, if a key value matche… --- ## [Unable to see use application and vlookup in studio 2021.4.4](https://forum.uipath.com/t/unable-to-see-use-application-and-vlookup-in-studio-2021-4-4/554295)
**Author:** [@Mathkar\_kunal](https://forum.uipath.com/u/Mathkar_kunal)\ **Replies:** 2\ **Last updated:** [June 15, 2023, 9:58am UTC](https://forum.uipath.com/t/unable-to-see-use-application-and-vlookup-in-studio-2021-4-4/554295 "2023-06-15T09:58:23Z")
hello, I am using 2021.4.4 but unable to find vlookup activity and use excel in activity section. i have lates updated excel package and aso selcted modern help me on same --- ## [How to look up a value row and apply arithmethic?](https://forum.uipath.com/t/how-to-look-up-a-value-row-and-apply-arithmethic/545882)
**Author:** [@JavRR](https://forum.uipath.com/u/JavRR)\ **Replies:** 2\ **Last updated:** [May 19, 2023, 8:36am UTC](https://forum.uipath.com/t/how-to-look-up-a-value-row-and-apply-arithmethic/545882 "2023-05-19T08:36:16Z")
I have a table, on which I need to review each row item into different columns. For example, I have first value row and I have to look for if the “ship to”, “company part number” and “UOM” matches with my conversion tab… --- ## [Using a Vlookup on an Excel pivottable cannot find a match](https://forum.uipath.com/t/using-a-vlookup-on-an-excel-pivottable-cannot-find-a-match/531353)
**Author:** [@bas.henssen](https://forum.uipath.com/u/bas.henssen)\ **Replies:** 2\ **Last updated:** [March 31, 2023, 10:36am UTC](https://forum.uipath.com/t/using-a-vlookup-on-an-excel-pivottable-cannot-find-a-match/531353 "2023-03-31T10:36:09Z")
Hello all, I’m running into some issues with a Vlookup function and I was wondering if anyone could help. The function is in a workflow that is supposed to check for a value in an excel pivottable. To test, I’ve simply … --- ## [VLookup LINQ - Multiple Columns](https://forum.uipath.com/t/vlookup-linq-multiple-columns/529526)
**Author:** [@Neal369](https://forum.uipath.com/u/Neal369)\ **Replies:** 10\ **Last updated:** [March 26, 2023, 3:12pm UTC](https://forum.uipath.com/t/vlookup-linq-multiple-columns/529526 "2023-03-26T15:12:34Z")
Hello Friends, Data.xlsx (12.4 KB) In attached file, we have “DataTable” and “LookupValues” sheets. we have to do Vlookup for all values in “LookupValues” sheet. DataTable - “DataTbl” variable LookupValues - “lookup\_… --- ## [How to implement VLOOKUP Formula between 2 different excels](https://forum.uipath.com/t/how-to-implement-vlookup-formula-between-2-different-excels/524464)
**Author:** [@Betul\_Dundar](https://forum.uipath.com/u/Betul_Dundar)\ **Replies:** 9\ **Last updated:** [March 9, 2023, 9:25am UTC](https://forum.uipath.com/t/how-to-implement-vlookup-formula-between-2-different-excels/524464 "2023-03-09T09:25:03Z")
Hi! I have a 2 excels. I can’t use read range activities because data is too big. I have a formula but, I don’t know how to implement this formula within Excel Application Scope Write Cell. =IFERROR(VLOOKUP(AP2;‘1SDR 2… --- ## [Compare cells and fill data in excel](https://forum.uipath.com/t/compare-cells-and-fill-data-in-excel/487032)
**Author:** [@Lynx](https://forum.uipath.com/u/Lynx)\ **Replies:** 2\ **Last updated:** [November 4, 2022, 4:48pm UTC](https://forum.uipath.com/t/compare-cells-and-fill-data-in-excel/487032 "2022-11-04T16:48:23Z")
Good afternoon friends; compare\_and\_fill.xlsx (11.1 KB) One query please, I would like to fill in the exchange rate in the sheet “data” column “D” according to the date, taking as reference the date and the exchange ra… --- ## [Why Am I getting blank values on these cells? - Vlookup activity](https://forum.uipath.com/t/why-am-i-getting-blank-values-on-these-cells-vlookup-activity/479154)
**Author:** [@pprin001](https://forum.uipath.com/u/pprin001)\ **Replies:** 5\ **Last updated:** [October 11, 2022, 5:10am UTC](https://forum.uipath.com/t/why-am-i-getting-blank-values-on-these-cells-vlookup-activity/479154 "2022-10-11T05:10:32Z")
Hello, community. I’d like to know Why I’m getting blank values despite the target value row being the same as the other sheet value of the file. If this wasn’t working, it wouldn’t fill the first 2 cells. The desire… --- ## [Extracting the data using two excel file having one common column](https://forum.uipath.com/t/extracting-the-data-using-two-excel-file-having-one-common-column/466780)
**Author:** [@sunain\_chahar](https://forum.uipath.com/u/sunain_chahar)\ **Replies:** 8\ **Last updated:** [August 22, 2022, 6:52pm UTC](https://forum.uipath.com/t/extracting-the-data-using-two-excel-file-having-one-common-column/466780 "2022-08-22T18:52:26Z")
I have two different excel file(Country , State) so i want to extract the using both the excel files. i want the output like image i have uploaded and i have also uploaded the two excel file Country.xlsx (8.4 KB) Stat… --- ## [Adding additional details in Excel usking vlookup](https://forum.uipath.com/t/adding-additional-details-in-excel-usking-vlookup/465068)
**Author:** [@sunain\_chahar](https://forum.uipath.com/u/sunain_chahar)\ **Replies:** 3\ **Last updated:** [August 15, 2022, 10:05am UTC](https://forum.uipath.com/t/adding-additional-details-in-excel-usking-vlookup/465068 "2022-08-15T10:05:20Z")
In this code the bot is downloading the excel file from SAP and as we can see in Figure one for certain “Billing Document” the value of Bill documents remain same but GT invoice changes So currently bot is picking up on… --- ## [Vlookup+ New Column Range Help!](https://forum.uipath.com/t/vlookup-new-column-range-help/444633)
**Author:** [@Jonathan\_Mbiriri](https://forum.uipath.com/u/Jonathan_Mbiriri)\ **Replies:** 5\ **Last updated:** [June 10, 2022, 8:11am UTC](https://forum.uipath.com/t/vlookup-new-column-range-help/444633 "2022-06-10T08:11:20Z")
Hi there, need help on excel. I have two excel sheets (Brian & Alex with exact same fields) that should be populated based on the values on “data” sheet. More of a vlookup. However if the date in “column c”- data2 sheet … --- ## [Vlookup to perform lakhs of data](https://forum.uipath.com/t/vlookup-to-perform-lakhs-of-data/368292)
**Author:** [@Anjali\_Rani](https://forum.uipath.com/u/Anjali_Rani)\ **Replies:** 21\ **Last updated:** [December 16, 2021, 7:48pm UTC](https://forum.uipath.com/t/vlookup-to-perform-lakhs-of-data/368292 "2021-12-16T19:48:00Z")
Hi everyone, I have two excels with more tan lakhs of data and i have to perform vlookups on first dt, and if common value found then replace their price with dt2 value. I tries this solution but this is not working. … --- ## [Datatable Compare to Swap values](https://forum.uipath.com/t/datatable-compare-to-swap-values/365766)
**Author:** [@Anjali\_Rani](https://forum.uipath.com/u/Anjali_Rani)\ **Replies:** 5\ **Last updated:** [December 1, 2021, 6:55am UTC](https://forum.uipath.com/t/datatable-compare-to-swap-values/365766 "2021-12-01T06:55:38Z")
Hi, Can anyone please help me to solve this please!! I have two DTs , Item1 and Item2, and i have to compare Item1 “SellCode” by Item2 “SCode”, If found then their price and Quantity will update by Item2 "Price"…