Interactive Table in Excel (Change Values based on dropdown list)

[koskesh]

Hi, I need help with an interactive table in Excel.
I want to change the values in a table based on a dropdown list. Im pretty sure I need the offset function but can't figure out how.

Many thanks

 

[Abdul Matheen]

Hi,

I am not clear about your requirment, but i have done a formula as per my understanding. check that and let me is that you are looking for.

if this formula meets your requirement then please click on LIKE.

Regards
Abdul Matheen

 

[koskesh]

thank you, thats exactly what I needed