SOLVED

Using index and match and return

Copper Contributor

Hello

 

Could someone intelligent and experienced person solve this problem? See attached.

I can also pay for this solution/formula if someone can solve it. 

ClauP

3 Replies
best response confirmed by ClauP (Copper Contributor)
Solution

Hi,

 

That could be

=IF($E2=$E1,$B1,$A2)

see in column M attached

Wow, that really worked for all those cells!! Incredibel!

I would like to give you a small amount of money 10$ if possible to show appreciation. 

:)

Thanks, glad to help free of charge

1 best response

Accepted Solutions
best response confirmed by ClauP (Copper Contributor)
Solution

Hi,

 

That could be

=IF($E2=$E1,$B1,$A2)

see in column M attached

View solution in original post