| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using VLOOKUP results in a DSUM criteria range
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using VLOOKUP results in a DSUM criteria range
On May 21, 1:39 pm, bluefish
wrote: 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using VLOOKUP results in a DSUM criteria range
Hello Spiky
Tried putting vlookup inside of Text function. Has no effect. Thanks for trying. Bluefish "Spiky" wrote: On May 21, 1:39 pm, bluefish wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DSUM - non contiguous criteria range | Excel Worksheet Functions | |||
| DSum criteria | Excel Worksheet Functions | |||
| dsum returns 0 if criteria range too large | Excel Worksheet Functions | |||
| Search Range for Criteria in given cell and produce results | Excel Discussion (Misc queries) | |||
| Disjoint range for DSUM criteria | Excel Worksheet Functions | |||
Hybrid Mode
