Pull data from excel based on column and row value

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!

1 comment

  • 0
    Pratyusa Ray

    Hi Blake,

    Thanks for reaching out.

    You can try and use the GroupBy function and see if that helps in your case.

    In order to help you better, I'd encourage you to create a support ticket with support@klipfolio.com for this issue, as I'm not able to effectively troubleshoot this without more information about your data and Klip. 

    Kind Regards,

    Pratyusa Ray





Please sign in to leave a comment.