Hi,
i have attached my project work sheet and i want retrieve xref,rqst sheet and populated in target sheet(see attached sheet) as per below condition
1. if sem_cin=cin then get ip_ip related sem_cin
2. if sem_cin is null or other than number then use cin=cdkey then get ip_id
3. if sem_cin=cdkey then match use sem_cin=cin get ip_id
please see attached requirement sheet and let me know if you need any further details
i have attached my project work sheet and i want retrieve xref,rqst sheet and populated in target sheet(see attached sheet) as per below condition
1. if sem_cin=cin then get ip_ip related sem_cin
2. if sem_cin is null or other than number then use cin=cdkey then get ip_id
3. if sem_cin=cdkey then match use sem_cin=cin get ip_id
please see attached requirement sheet and let me know if you need any further details