=vlookup(P2,sheet6!B:H,7,0)
How to fill in lookup data table properties.
=vlookup(P2,sheet6!B:H,7,0)
How to fill in lookup data table properties.
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:
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
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:
P2
).7
).sheet6
).7
).lookupResult
).Thanks!!