Vlookup derived wrong value
Try this:
A5: is your criteria
=SUMPRODUCT(--(A1:A2=A5),B1:B2)
"Michelle" wrote:
Formula used for LastMthCost is =vlookup(A2,LastMthCost!A2:B3,2,FALSE)
Instead of returning 1.5 but i got 2.5!!!!! Please help
Worksheet: ThisMthCost
A B
1 PartNum LastMthCost
2 M03541224*a 2.5
Worksheet: LastMthCost
A B
1 PartNum LastMthCost
2 M03541224**a 2.5
3 M03541224*a 1.5
|