Forum Discussion
Syndicate_Admin
Administrator
AdministratorLOOKUPVALUE blank rows
Hello Does anyone know why I don't search in all the ranks the same? I use LOOKUPVALUE and some find them and some don't. Thank you.
Syndicate_AdminAdministrator
AdministratorI have a clue that can help because it is still eye-catching. I have reviewed the entire list and all the ones that I am missing (which are blank although it should have value), are those that the column "month" is 3. ALL.
johnt75Super User
Not sure that that helps, as in the screenshot you posted there is a row from month 3 which does have a value. I think that the problem will ultimately have to do with the representate column.
Do you have any values in rows for month 4? Just wondering if something changed in the source system part way through March. But you have a value missing on March 13 then a value correctly appearing on 21 March, then it disappears again on 31 March, so that might be a red herring.