HLOOKUP? Find Value, then take Value 2 Above in Column

Hey everyone, humble public servant of the US Air Force having trouble with HLOOKUP.

I need to find a value, and then take a value that is 2 above my found value in the same column.

Attached is a picture, the blue circled cell is what I need to start from, and then the red circle is the value I need to return.

WhatINeed.PNG

My HLOOKUP doesn't seem to be workin the way the tutorials say
=HLOOKUP(A8,'CURRENT C17'!B2:B100,-2,FALSE)

I'm looking in Column B, I should be going 2 above the located value.
A8 = 04-4135


Any help will end up saving Tax Payer Dollars, Thanks!

INDEX/MATCH is the way to do this. Try this formula:

=INDEX('CURRENT C17'!B2:B100,MATCH(A8,'CURRENT C17'!B2:B100,FALSE)-2)

Note that you will have problems if you match on the first two items.

Also, I can't download your attachment - it would be better to attach an Excel workbook rather than a picture of one.

Hope this helps.

Pete

Thanks everyone, you got me what I was looking for!