Smartsheet Formula Reference to another sheet

mragans23

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 :(

Brad Schutts

I use Vlookups but you will not be able to move columns around if you do since it is based on the column number that it is in the array - https://help.smartsheet.com/function/vlookup. You can also use Index and Match to avoid that but it's just something I'm not used to - https://help.smartsheet.com/function/match.

This is what I'd think your vlookup would look like: "=vlookup({{HI Rate Code}}, {{Array from Other Sheet starting with column HI Rate Code}}, {{Column Number for HI Rate Amount}},false)"