Any Excel gurus

[roro]

Appreciate any help with following excel formula query
If one cell contains a given text, then how do I take a $ value from a second cell and insert that $ value in third cell

 

[hogjowl]

Appreciate any help with following excel formula query
If one cell contains a given text, then how do I take a $ value from a second cell and insert that $ value in third cell

My son-in-law is a somewhat amateur guru at it. He can whip up a spread sheet that works wonderfully for about a week.

 

[Mikey P]

Does this help?


View: https://youtu.be/2u4BbyjL-fY?si=vhbwCcPAPKyR9soi

 

[Brian H]

If this is what you want to do, here is the easy formula:

 

[Brian H]

You can also use this formula, though it's a bit more complicated:

I came up with the first one, and my wife who is an advanced Excel user came up with the 2nd one.

 

[roro]

Thanks all but ended up doing it hard way 1017 lines