I have a different requirement here...
I have two data sets .
First one brings the Location , Department
2nd one brings in another table (Joined).
I need to check if Devicename in Dataset2 is in Dataset1 and bring the EmpTenure from Dataset2.
something like -
=LOOKUP(Dataset1.DeviceName ,Datset2.deviceName,datset2.Emptenure,"Dataset2")
This brings everything that matches but at the same time I also need the rows where DeviceName in 2 has no match for devicename in Datset 1 and bring the EmpTenure) I know it will be Null But thats the requirement.... So basicallyt I need both Devices that match from Dataset2 to Dataset1 and Devices that do not match...