I have a table, starting at cell A2, like this:
List1 List2 List3 John Gail Steven Betty Mark Mark Bill John John
and a named range called Selected_Lists like this:
List1 List2 List3
The array formula {=IF(INDIRECT({"R2C1"},FALSE)=Selected_Lists,TRUE)} gives a #VALUE error.
If I highlight just the INDIRECT({"R2C1"},FALSE) portion and hit F9, it correctly evaluates to {"List1"}.
If I hardcode the cell R2C1 result into the formula like this:
=IF({"List1"}=Selected_Lists,TRUE)
It works just fine.
Why am I getting a data type mismatch with the INDIRECT function, and how can I correct it?
Thanks!
Bookmarks