nachiketdp
Board Regular
- Joined
- Jan 31, 2007
- Messages
- 53
Hi all,
I have got a worksheet whose Column C contains diffferent cell ranges. Column H contains an hlookup throughout. Now for all Column H entries, I am trying to enter the arguement "table array" of the hlookup as corresponding column C entry. However, I am getting all results as #N/A since the table array which is getting defined is nothing but the correspoding cell in Column C.
For eg. my cell C2 contains I4:I50. When I try to define the table array of the hlookup in H2 as C2(i.e. I want I4:I50 to feature in the hlookup formula) I get #N/A since the table array which is getting defined is nothing but C2.
So is there any solution for the above problem?
Any kind of help from you will be highly appreciated !!!
Regards,
Nachiket Pendharkar.
I have got a worksheet whose Column C contains diffferent cell ranges. Column H contains an hlookup throughout. Now for all Column H entries, I am trying to enter the arguement "table array" of the hlookup as corresponding column C entry. However, I am getting all results as #N/A since the table array which is getting defined is nothing but the correspoding cell in Column C.
For eg. my cell C2 contains I4:I50. When I try to define the table array of the hlookup in H2 as C2(i.e. I want I4:I50 to feature in the hlookup formula) I get #N/A since the table array which is getting defined is nothing but C2.
So is there any solution for the above problem?
Any kind of help from you will be highly appreciated !!!
Regards,
Nachiket Pendharkar.