Find Value in Range then

[Steves73]

Hi Guys

I have a cell range H4 - AT4, I have a formula that places a specific value in a cell within the range based on a value above, example - Formula places the number 5000 in cell Z4 using the value in cell Z3. That part works fine, now what I want to do is search the range H4-AT4, find the cell with the number 5000 in it, then use a formula to calculate the cell directly above it.

If a cell between H-4 and AT4 =5000 the use the cell value directly above in a calculation

I hope this make sense

 

[steve the fish]

Try this:

=INDEX($H$3:$AT$3,MATCH(5000,$H$4:$AT$4,0))

 

[Steves73]

Try this:

=INDEX($H$3:$AT$3,MATCH(5000,$H$4:$AT$4,0))

Hi Mate

Thank you very much, works perfectly