Hi,
I am having data as per attached sheet.
In this sheet in Sheet1 at row no 11,12, 26,27,41,42 i want to get data(account number) from Sheet2.
But the cells are reflecting only =Sheet2!D2 ,=Sheet2!D3 etc.
However in Row No 6,21,36 in Sheet1 i am getting required Name from Sheet2.
Please guide how to fix the error.
Thank You
kdraghu
Bookmarks