I need to lookup for a cell coordinates in excel using Lookup Range activity.
- The range will be the entire column AI. How to give the range value in this case?
- If suppose, I find first occurence of my value at AI5. Now I’ll use one more lookup range activity to search from AI5 to last row in column AI(Only in column AI). How to give range in this case?
Thanks in advance