I have a grid in excel. The column headers are Program names. The row headers are Tiers (numbered 1-7). Each cell is the dollar amount needed for each Program/Tier combination.
In my grid Klip, each row is a program and I have a column that calculates and displays Tier. I have another column called Rate that is currently blank. All I am trying to do is make a formula in Rate that will look at the current row's program and tier, then pull the dollar amount from the excel grid for the matching program and tier. I've been spending a lot of time reading about the lookup function, but I don't think that's the full answer.
I did this exact exercise in excel and was able to easily pull it off using a lookup and match function combination in Excel. There's no Match function in Klipfolio, though. Maybe there's an equivalent.
Thanks for the help!