Forum Discussion
LOOKUPVALUE Randomly Returns Blank Values
I have a dataset with Names of volunteers and each one is given a unique ID number. In another table, I have some contacts and in that table, there is a column of with the Volunteer ID of the volunt...
Hi everyone,
I was getting empty spaces for some rows when using the lookupvalue formula between tables and changing relationships of those tables solved it.
I am not sure if following details make it more clearer:
BEFORE
Tables relationship (many to many): Masters.table_Column.A <---> Data.table_ColumnB
Lookupvalue function: Masters.table_Column.A <---> Data.table_ColumnG = giving empty spaces in some rows
AFTER
Tables relationship (many to many): Masters.table_Column.A <---> Data.table_ColumnG
Lookupvalue function: Masters.table_Column.A <---> Data.table_ColumnG = not giving any empty spaces now
Note:
In above scenario Data.table_ColumnG & Data.table_ColumnB had names but not in same order. These names could be found in Masters.table_Column.A