Grid Index/V-lookup Help

Originally Posted by egren

Sorry I didn't realize you posted another reply. The offset formula worked perfectly but the second with with indexes did not work and gave me incorrect results.. Why would the OFFSET formula be volatile?

I Attachment 657126

This is the result of the other one - maybe i did something wrong?

Yep!

Looks like you've anchored the formula to the value in $M$5 so it's using 130 as the number to lookup resulting in 15000 budget in the Milwaukee district. I would recommend copying the exact formula I posted as using the wildcard is also going to be a little more reliable:

=HLOOKUP($M5,INDEX($C:$C,MATCH($L5&"*",$A:$A,0)):INDEX($H:$H,MATCH($L5&"*",$A:$A,0)+1),2,TRUE)

WBD