S sms2luv Member Mar 25, 2016 #1 Hi all, please check attach sheet. I have data in sheet 1, where survey field is blank. I want to get the value from sheet2, keeping in mind that name and date should match. Please help
Hi all, please check attach sheet. I have data in sheet 1, where survey field is blank. I want to get the value from sheet2, keeping in mind that name and date should match. Please help
S sms2luv Member Mar 25, 2016 #3 Attached Attachments CTI details.xls CTI details.xls 16.5 KB · Views: 10
V vletm Excel Ninja Mar 25, 2016 #4 @sms2luv Something like this ... Attachments CTI details.xls CTI details.xls 64 KB · Views: 20
S sms2luv Member Mar 25, 2016 #5 Just 1 word from me. YOU GUYS ARE REALLY AWESOME, WORDS CANNOT EXPRESS HOW HAPPY I AM WITH THIS. thanks A TON
Just 1 word from me. YOU GUYS ARE REALLY AWESOME, WORDS CANNOT EXPRESS HOW HAPPY I AM WITH THIS. thanks A TON
S sms2luv Member Mar 27, 2016 #6 Hi team, I am doing something similar as I though it would be easy but I am not getting what I need, please check highlighted cell Attachments cti.xlsx cti.xlsx 55.2 KB · Views: 18
Hi team, I am doing something similar as I though it would be easy but I am not getting what I need, please check highlighted cell
Deepak Excel Ninja Mar 28, 2016 #7 Is this... put in f2 & drag down.. =INDEX(Sheet2!$A$1:$H$49,INDEX(MATCH(Sheet1!A2&Sheet1!C2,Sheet2!$A$1:$A$49&Sheet2!$B$1:$B$49,0),,),MATCH(Sheet1!B2,Sheet2!$A$1:$H$1,0))
Is this... put in f2 & drag down.. =INDEX(Sheet2!$A$1:$H$49,INDEX(MATCH(Sheet1!A2&Sheet1!C2,Sheet2!$A$1:$A$49&Sheet2!$B$1:$B$49,0),,),MATCH(Sheet1!B2,Sheet2!$A$1:$H$1,0))
