csappington
New Member
- Joined
- Dec 15, 2020
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hello, I have different prices for each unit that I need to use depending on which Substation Line we are working on. Lets call the lines A, B, C, D, E, F, and G. I would like to enter the Substation Line that I am billing for in the Yellow Box, then those corresponding Substation Line unit prices will fall below next to each unit indicated in blue.
I have messed with the IF formula and the false option is throwing me off.
Basically if E3=A then E4="removal!C3". Then I can drag that down through the worksheet. After I F4 cell E3.
Or if E3=B then E4="removal!D3". Then drag that down too.
Pictures are attached.
Can anyone teach me how to do this? Much appreciated!
I have messed with the IF formula and the false option is throwing me off.
Basically if E3=A then E4="removal!C3". Then I can drag that down through the worksheet. After I F4 cell E3.
Or if E3=B then E4="removal!D3". Then drag that down too.
Pictures are attached.
Can anyone teach me how to do this? Much appreciated!