SUMPRODUCT with incremental values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all

Thanks for all your help in the past

I have a formula :
=(VLOOKUP(H3,STIR!$E$3:$I$622,3,FALSE)*M3)+(VLOOKUP(H3,STIR!$E$3:$I$622,2,FALSE)

STIR! columns G, H & I has $ values, the headers are 250, 500,100
Lets say the rows values are : 4, 6 &

So what I'm trying to achieve is lookup value M3 if it falls between 0 & 250 its 4, 251 & 500 its 6 et

I've triedadding a HLOOKUP (M3, $E$3:$E$622,3,true

But it doesn't wor

Help

Thank

Alby
 
Alby,

If you change the headers in G, H, I to 0, 250, 50, this will work

=INDEX($A$2:$D$2,1,MATCH(M3,$A$1:$D$1,1))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top