Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey,
Does anyone know how to convert this Excel V-Lookup into a QV formula?
=TODAY()-(VLOOKUP(VLOOKUP(J2,A:L,10),A:L,11))
Thanks!!
Examples:
Lookup:
ApplyMap():
Thanks, I have a basic ApplyMap working. How would I do a nested ApplyMap?
Here is the working one
Today()- ApplyMap('Ref', Dependent, null()) as Dependency2
Here is the nested VLookup I'm trying to mirror
=IF(Ref="","",TODAY()-(VLOOKUP(VLOOKUP(Dependent,Risk!A:L,Dependent),Ref,TargetDate)))
I attempted with an nested ApplyMap but appear to have broken it
Please post sample data of both tables
Post your formula.
Hi,
Here is the nested formula I am trying, It has syntax errors, any ideas?
Today()- ApplyMap(ApplyMap('Ref', Dependent, null()), 'Ref', Dependent, null()) as Dependency1,
I also tried this one:
Today()- ApplyMap('Ref',ApplyMap('Ref', Dependent, null()), Dependent, null()) as Dependency1,
Please check below is my example:
Script:
Output:
To create the temp table and resident the to the particular table it may be get the values.
As per your formula mentioned above (VLOOKUP(Dependent,Risk!A:L,Dependent)), you have more than two columns from source table so use lookup() function to get the target column value.