Smartsheet Formula Reference to another sheet

I am creating several different budget sheets. In these I want to reference one reference sheet.

For example in my current sheet:

I am looking to say If Column names: HI Rate Code = HR Rate Code from sheet name: Reference Guide then bring over the # listed in Sheet Name Reference Guide, Column Name: HI Rate Amount.

Help :(


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!