Hi,

how to create dynamic named range with reference to dynamic table?

Screenshot_2.png

I have Server and offered table.
And now i want to create named range NR_WindowMax and point this to Windows and 1000 from Offered
NR_LinuxMax should point to Linux and to 2000 from offered.

How to do this?

I was trying to do something like this:

=IF(INDIRECT("t_MaxMemory[Server]")="Windows";INDIRECT("t_MaxMemory[Server]");"ok")
but this is showing only "ok"...

Please help,
Jacek