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:
but this is showing only "ok"...![]()
=IF(INDIRECT("t_MaxMemory[Server]")="Windows";INDIRECT("t_MaxMemory[Server]");"ok")
Please help,
Jacek
Bookmarks