I have a 2 datatables Dt1 : having columns fname,lname,concat Dt2 : having columns address,concat I am looking for address using vlookup and this lookup value will come in Dt1, how to pass the range dynamically.?? Can somone help out for this scenario on how to do lookup here for range data

Dynamic range lookup

sreejith.ss (Sreejith Ss) October 30, 2022, 5:54am 4

@shivarajvp555
if no address is found for that contact
The column should be made blank or what?
Could you please explain that too.

Regards

Sreejith S S

Topic		Replies	Views
How to create a dynamic Lookup Datatable? Help studio	20	2381	September 23, 2020
Finding a dynamic range in Excel Help datatable , excel , studio , question	2	751	September 29, 2020
data table lookup Activities datatable , studio , question , system	2	2499	November 24, 2021
LookupData table Activity Issue Help datatable , excel , activities , question	1	1177	November 28, 2019
Lookup DataTable Activities excel , activities , question	5	720	December 15, 2023