Hi SM Sir, please see the uploaded sample file and help me out.
R Ramesh Deo Member Jul 23, 2014 #1 Hi SM Sir, please see the uploaded sample file and help me out. Attachments Help.xlsx 10.2 KB · Views: 7
Somendra Misra Excel Ninja Jul 23, 2014 #2 Hi Ramesh, Good to see you back. See the file, I had changed merged cell to Center Across selection. Regards, Attachments Help.xlsx 11.5 KB · Views: 11
Hi Ramesh, Good to see you back. See the file, I had changed merged cell to Center Across selection. Regards,
R Ramesh Deo Member Jul 23, 2014 #3 Somendra Misra said: Hi Ramesh, Good to see you back. See the file, I had changed merged cell to Center Across selection. Regards, Click to expand... First of all Thanks for this help sm sir, and i also happy to see you after a long time, and always be grateful to you.
Somendra Misra said: Hi Ramesh, Good to see you back. See the file, I had changed merged cell to Center Across selection. Regards, Click to expand... First of all Thanks for this help sm sir, and i also happy to see you after a long time, and always be grateful to you.
H Haseeb A Active Member Jul 26, 2014 #4 Hello Ramesh, You could also use just HLOOKUP =HLOOKUP(B$12,INDEX($3:$3,MATCH($A13,$1:$1,0)):$AB$4,2,0)
Hello Ramesh, You could also use just HLOOKUP =HLOOKUP(B$12,INDEX($3:$3,MATCH($A13,$1:$1,0)):$AB$4,2,0)