Quote:
Originally Posted by 81MC
Hi,
Sorry, nothing worse than bringing spreadsheets up on a hockey forum, I know.
Can someone please tell/remind me what the hell the thing I’m trying to do is called? I’ve done it in the past years ago, now I can’t recall how I saved it.
Column 1 has 1500 unique variables. Column 2 has 100 variables. Column two Value is tied to certain variables in Column 1. These are already tabled, and consistent.
I’d like to avoid long-ass IF arguments and formulas as I refer to this data across a ton of stuff. If anyone can help me out and remind me what this type of saved custom list is called, I’d be really grateful.
|
Are you thinking of using a data validation formula in the second column? e.g. =INDIRECT to determine which column the source variable is consistent with?