nachiketdp
Board Regular
- Joined
- Jan 31, 2007
- Messages
- 53
Hi all,
I have a workbook which has a sheet namely "Working". This sheet has in its Column G ranges referring to several other worksheets in the same workbook eg(ABCD!$A$1:$IA$35).
In Column I there is an hlookup throughout which uses the corresponding range present in Column B as the table_array using indirect function for eg(=HLOOKUP($E2,INDIRECT($G2),15,0).
Now my problem is that I am getting the error #REF! for some row-items. All the corresponding worksheets for these row-items are present in the workbook. None of them is hidden or very-hidden.
Any idea why this could be happening? Any help will be highly appreciated !!
Thanks in advance,
Nachiket Pendharkar.
I have a workbook which has a sheet namely "Working". This sheet has in its Column G ranges referring to several other worksheets in the same workbook eg(ABCD!$A$1:$IA$35).
In Column I there is an hlookup throughout which uses the corresponding range present in Column B as the table_array using indirect function for eg(=HLOOKUP($E2,INDIRECT($G2),15,0).
Now my problem is that I am getting the error #REF! for some row-items. All the corresponding worksheets for these row-items are present in the workbook. None of them is hidden or very-hidden.
Any idea why this could be happening? Any help will be highly appreciated !!
Thanks in advance,
Nachiket Pendharkar.