Perform vlookup in excel without using lookup data table

Help
1

How to perform vlookup in excel without using lookup data table activity and store the result at last after last column of the excel sheet?

1 Like
2

You can very well use the click and type activities to do this over the excel UI.
Also, here is another component that I found over connect that might be helpful. You may explore it, I haven’t used it though.

2 Likes
3

@Palaniyappan Can you help?

1 Like
4

Hi
Look up datatable is very easy to use and I wonder why we are avoiding to use
But still we can do the same with vlookup excel formula with write cell activity inside a for each row loop
Or
We can do that with a vb script which we can run with execute macro or invoke VBA activity

Cheers @vamsikrish28

3 Likes
5

Yes, Lookup Datatable is very easy and convenient.
Let us know if you need any help with that too @vamsikrish28.

6

Thanks and cheers @Palaniyappan :grinning:

1 Like
7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.