CODEWITHSUNDEEP
excelexcel-formula
Oryza Sativae
Oryza Sativae

Reputation: 99

Sum with Datedif Formula

Ihave a formula like this

=IF(DATEDIF(D4;DATE(2014;8;31);"Y")>15;DATEDIF(D4;DATE(2014;8;31);"Y")*12500+VLOOKUP(VALUE(LEFT(C4;1));$U$22:$Z$25;7;FALSE);0)

But returned a #REF! results, can you tell me what's wrong on this formula?

Upvotes: 0

Views: 147

Answers (1)

Máté Juhász
Máté Juhász

Reputation: 2327

One obvious mistake I see is here :

VLOOKUP(VALUE(LEFT(C4;1));$U$22:$Z$25;7;FALSE

$U$22:$Z$25 has only 6 columns but you want to get value from the 7th.

Upvotes: 1

Related Questions