INDIRECT with VLOOKUP

[tlawson1]

Hi All

I have a cell named "LookUp_Table". This cell contains the Text for the Worksheet in which my Table resides.

I am using a VLOOKUP Formula =IF(VLOOKUP(Tax_Week,INDIRECT(LookUp_Table),6)=0,"",VLOOKUP(Tax_Week,INDIRECT(LookUp_Table),6))

This Formula works fine and will return an empty string rather than a Zero if my LOOKUP value is empty (which is what I want).

My problem is when I try and add this result to another Cell then I get a #VALUE! error.

Any ideas on how to solve this.

Many thanks
Tony

 

[Peter_SSs]

One way is to use SUM instead of "+". So if you are adding A2 and G5 use
=SUM(A2,G5)

 

[tlawson1]

Many Thanks that has solved my problem

Tony