If/Then Formula Not Drawing Across Sheets

[Matt010614]

I have an If/Then formula setup within a worksheet that is as following:

=IF(B23="Installation", C23=0, IF(B23="1m Pickup", C23=Rates!$B$2, IF(B23="2m Pickup", C23=Rates!$B$3, IF(B23="1m Bucket", C23=Rates!$B$4, IF(B23="2m Bucket", C23=Rates!$B$5, IF(B23="1m Crane", C23=Rates!$B$6, IF(B23="2m Crane", C23=Rates!$B$7, IF(B23="High Time", C23=Rates!$B$8))))))))

Installation, 1m Pickup, etc. are setup in a drop down menu in "Base" Sheet B23. The formula should populate the rate from my "Rates" sheet in "Base" cell C23 (the above function is in "Base" cell C23) based on which item is selected from the drop list. The function resolves without error, but does not populate anything other than "0" for my rate. Any ideas?

Thank you!

[#2]

@Matt010614 

I guess that formula shall be in C23 as

=IF(B23="Installation", 0, IF(B23="1m Pickup", Rates!$B$2, IF(B23="2m Pickup", Rates!$B$3, IF(B23="1m Bucket", Rates!$B$4, IF(B23="2m Bucket", Rates!$B$5, IF(B23="1m Crane", Rates!$B$6, IF(B23="2m Crane", Rates!$B$7, IF(B23="High Time", Rates!$B$8))))))))

[#3]

@Sergei Baklan Agreed, I realized after I posted that I was referencing cell C23 in error.

Thanks!!