Excel CONCATENATE function

[ChuckM]

Having a problem related to this function, ie.

=IF(HLOOKUP(C18,VendorTable,2),SUM(CONCATENATE
(D18,"work") - F18),"f")

The Hlookup verifies that the vendor is listed

The SUM "should" subtract the value in F18 from the
balance in a named cell. The name of the cell is built
from the name in the vendor list and the literal "work".
Sound good?? Doesn't work... The complete name for the
named cell is good, but contains quotes on both ends
(verified with the trace). It cannot use the literal in
a SUM function.

Anyone know of another function I could use, or know of a
way aroung this?

This is used in a Daily Journal for an accountant.

 

[Frank Kabel]

Hi
you probably mean:
=IF(HLOOKUP(C18,VendorTable,2),INDIRECT(D18&"work") - F18,"f")

 

[Guest]

You are absolutely right! You guys are good.
Thanks Frank

 

[Guest]

Oh boy,

The statement worked for the first occurance, then
died. Didn't matter if it was the same entry in the
VendorTable or not.
Recreated the VendorTable - same problem. Recreated the
named cells - didn't help. Although that first entry
worked throughout the changes.

 

[Frank Kabel]

Hi
posz the exact formula used and the values in the cells