Using VLOOKUP results in a DSUM criteria range

[bluefish]

I use vlookup to put a string in cell A10. Then I use A10 in the criteria
range of a dsum function. Dsum returns "0" when I know that the sum should
be "100". Here is what I see in A10:

vlookup shows me "Large Cap" text in A10. but if I use function keys F2 &
F9 on Cell A10, then I see this, "{Large Cap}" including the quotes.

If I type "Large Cap" directly into A10, then Dsum finds the correct sum.
but it returns "0" if I let vlookup provide the text "Large Cap".

A10 needs to be flexible. I cannot retype the vlookup results or copy/paste.

I have used this type of vlookup/dsum formula without a problem in the past
but I have never seen the "{....}" result before now.

Please help me get my worksheet to work again. Thanks

bluefish

 

[Spiky]

I use vlookup to put a string in cell A10. Then I use A10 in the criteria
range of a dsum function. Dsum returns "0" when I know that the sum should
be "100". Here is what I see in A10:

vlookup shows me "Large Cap" text in A10. but if I use function keys F2 &
F9 on Cell A10, then I see this, "{Large Cap}" including the quotes.

If I type "Large Cap" directly into A10, then Dsum finds the correct sum.
but it returns "0" if I let vlookup provide the text "Large Cap".

A10 needs to be flexible. I cannot retype the vlookup results or copy/paste.

I have used this type of vlookup/dsum formula without a problem in the past
but I have never seen the "{....}" result before now.

Please help me get my worksheet to work again. Thanks

bluefish

Try wrapping a TEXT() function around the VLOOKUP.

 

[bluefish]

Hello Spiky
Tried putting vlookup inside of Text function. Has no effect.
Thanks for trying.
Bluefish