Forum Discussion
Excel - Table error - #value!
Per NikolinoDE, adding pertinent information to the request. Thank you, NikolinoDE. System information: Windows 11 Pro-64 bit. Microsoft 365 MSO version 2403, build 16.0.17425.20176 64 bit. O...
It looks like you work with named ranges, not with structured table. If you have named range "MyRange" and reference on it as
=@MyRange
it returns the value from exactly the same row of MyRange where the formula is entered. If above formula is in row 31 it returns the value from MyRange from row 31. If MyRange is in rows 2-17 (i.e. not defined for row 31), formula returns #VALUE! error - nothing from above range in row 31.
If you would like to reference on MyRange in another rows, as one of variants that could be
=INDEX(MyRrange, ROW()-ROW(header) )where "header" is reference on the cell with target header.
- Thank you kindly for the response. I will work my way through the INDEX process-this will be the first time for me to use it. Your explanation is much appreciated.
