Dynamic Excel Table Inputs Based on Cell Value

In this video we are going to learn how to use the =INDIRECT function to create flexible inputs for Excel Table formulas. An indirect structured table reference will allow us to quickly evaluate data sets based on different fields. This will allow us to review each column header without rewriting the formula.

[@RTimo]

This is top tier! Can be also used for timesheets/accrual

[@ProduccionesLukaz]

thanks!

[@tarynhentz8617]

I use this formula in a template used weekly. How can I make the formula apply when I copy and paste the template!?

[@TheRichardoboh]

Wow! Impressive

[@ASimpleModel]

Thanks!

[@tarunbrahmabhatt2711]

How can plot a dynamic line between two strike price of option chain according spot price

[@mrgr]

Would this be useful for my problem: i have x number of methods for a calculation of a problem, if i choose one, i need excel to show me input fields for that calculation and then calculate once i insert them, then if i choose another method i need excel to offer me different input fields and calculate by another different equation and so on. Is this possible?

[@PritamDas-wl7yy]

=INDEX( XX:XX, MATCH(XX:XX))