Return the next row value based on criteria

[Hesham121]

Hello Dears,

I need to look for a value within a range and get the next row value if found with specific formating, attached is an example for what expected.

[davesexcel]

What would the result be if I5=141 or K5=154?

[windknife]

I6

Please Login or Register  to view this content.

[Hesham121]

What would the result be if I5=141 or K5=154?

Then I6=M-01 (152) AND K6=M-02 (187)

[Hesham121]

I6

Please Login or Register  to view this content.

Thank you Windknife, your solution is working well!

[windknife]

You are welcome.

--------------------------------------
If that takes care of your original question, please click on "Thread Tools" from the menu link above and mark this thread as SOLVED.

[Hesham121]

You are welcome.

--------------------------------------
If that takes care of your original question, please click on "Thread Tools" from the menu link above and mark this thread as SOLVED.

Thanks, I'll mark it as SOLVED... but can you please help in fixing the attached formula, sometimes I need to get just the cell value without any substitution.

[windknife]

I6

Please Login or Register  to view this content.

[Hesham121]

Thank you so much!