Another IF question.

[csappington]

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!

 

[Fluff]

Hi & welcome to MrExcel.
How about

=INDEX(Removal!$C$3:$I$100,MATCH(D4,Removal!$B$3:$B$100,0),MATCH(E$3,Removal!$C$2:$I$2,0))

 

[csappington]

Hi & welcome to MrExcel.
How about

=INDEX(Removal!$C$3:$I$100,MATCH(D4,Removal!$B$3:$B$100,0),MATCH(E$3,Removal!$C$2:$I$2,0))

That works perfectly! Thank you very much!

 

[Fluff]

Will the col D values on sheet1 always be exactly the same as the col B values on Removal?
ie no missing values & in the same order
If so you could use

=FILTER(Removal!$C$3:$I$100,Removal!$C$2:$I$2=E3)

 

[csappington]

Will the col D values on sheet1 always be exactly the same as the col B values on Removal?
ie no missing values & in the same order
If so you could use

=FILTER(Removal!$C$3:$I$100,Removal!$C$2:$I$2=E3)

They were given to us all in the same order luckily! Thank you again. Great job.

 

[Fluff]

Glad to help & thanks for the feedback.