Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Lookup with Twist Expand / Collapse
Posted Sunday, March 23, 2014 3:58 PM


Group: General Forum Members
Last Login: Wednesday, November 30, 2016 3:27 PM
Points: 406, Visits: 1,217
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...
Post #1553840
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse