Vlookup data in Excel

[AsadPathan2665 (Asad Pathan)]

=vlookup(P2,sheet6!B:H,7,0)

How to fill in lookup data table properties.

[AshwinS2 (Ashwin S)]

Hi @AsadPathan2665

Try this

Excel VLookup Activity not working in StudioX

Hi, I have issues using the VLookup activity in StudioX, also the explanation in the Academy doesn’t seem to be explaining how to use the function. [image] Can you please send some examples on the correct syntax? What data needs to be in “Source Range”, “Search for values”, “Column Index”, “Exact match” and “Output to”? Can you please compare this with a Excel Vlookup function? Thanks! Tom

Thanks
Ashwin.S

[adiijaiin (Aditya Jain)]

Hi @AsadPathan2665

To use the Lookup DataTable activity.
You would first have to read the excel range and store it in a DT
and then pass these parameters:

Use Row number for obtaining details whatever it is that you want.
for eg:
DataReadFromExcelRange.Rows(CaptureRowNumber)(“DataFetchColumnName”)

Hope this helps!

Or else if you wanna use this function directly in Excel, you can write it in the 1st cell and use auto fill range.

Thanks

[Nitya1 (Nitya Tomar)]

Hi @AsadPathan2665

you can use the “Lookup Data Table” activity. This activity allows you to search for a value in a specified column of a DataTable and return a matching value from another column.

Here’s how you can fill in the properties of the “Lookup Data Table” activity to achieve the desired result:

1. Specify the input values:

• Set the “ValueToLookUp” property to the value you want to search for (e.g., P2).
• Set the “SearchInColumnIndex” property to the index of the column in the DataTable where you want to perform the lookup operation (e.g., 7).

2. Specify the DataTable:

• Set the “DataTable” property to the DataTable variable that contains the data you want to search in (e.g., sheet6).

3. Specify the output properties:

• Set the “TargetColumnIndex” property to the index of the column from which you want to retrieve the matching value (e.g., 7).
• Set the “Result” property to a variable of the appropriate type to store the result of the lookup operation (e.g., lookupResult).

Thanks!!