Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 9:09 AM
Points: 215, Visits: 638
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