Using VLOOKUP results in a DSUM criteria range

B

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
 
S

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.
 
B

bluefish

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top