Using =sum to add values of vlookup formula

L

loscherland

When i use =SUM(D2:E2) it returns 0
When i use =D2+E2 it returns #VALUE!
When i use =SUM(D2+E2( it returns #VALUE!
When i use =(VLOOKUP(B2,'Mont
1'!$C$3:$F$28,4,FALSE))+(VLOOKUP(B2,'Month 2'!$C$3:$F$28,4,FALSE)) i
returns #VALUE!

When I change the VLOOKUP formula's to =--VLOOKUP, they return #VALUE!

I changed the format of the data the tables for Month 1 & Month 2 t
numeric but it didn't make any difference
 
G

Guest

Hi
changing the format won't help. Your data is NOT numeric. You may really
check your source data. Maybe invisible charaters, etc.
 

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

Similar Threads

Using =sum to add values of vlookup formula 2
VLOOKUP problem 3
vlookup useful? 2
Average problem 1
Vlookup 3
vlookup and sum of colums 5
Vlookup and adding text 3
Conditional sum, when condition has multiple values 3

Top