L
Lord Kelvan
Hi
I am trying to sum the results of a vlookup in one cell
I have a series of cells
B3:b37
Which have a series of text values
These match up to a lookup table on another sheet
Othersheet!a3:b8
I want to lookup each of the values in b3:b37 and match them to the
lookup table and return the sum of these values
I have looked around the net and found some things but none seem to
work this one worked but the value it returns is incorrect
=SUMPRODUCT(--(ISNUMBER(MATCH(INDEX(othersheet!
A3:b8,,1),B3:B37,0))),INDEX(othersheet!A3:b8,,2))
Any assistance would be helpful
Regards
Kelvan
I am trying to sum the results of a vlookup in one cell
I have a series of cells
B3:b37
Which have a series of text values
These match up to a lookup table on another sheet
Othersheet!a3:b8
I want to lookup each of the values in b3:b37 and match them to the
lookup table and return the sum of these values
I have looked around the net and found some things but none seem to
work this one worked but the value it returns is incorrect
=SUMPRODUCT(--(ISNUMBER(MATCH(INDEX(othersheet!
A3:b8,,1),B3:B37,0))),INDEX(othersheet!A3:b8,,2))
Any assistance would be helpful
Regards
Kelvan