Sep 01 2020 02:55 AM
Hello friends, could you help me, I need my data list when selecting an item to fill in other columns automatically,
I tried to use this formula
= IF (ISERROR (VLOOKUP ([@ Name]; 'Store Assistants'! A24: $ F $ 1000; 2; FALSE)); ""; (VLOOKUP ([@ Name]; 'Store Assistants' '! A24: $ B $ 1000,2; FALSE)))
it just doesn't work when the column containing the list is empty.
Sep 01 2020 05:33 AM
In both VLOOKUP you selected column 2, thus they return exactly the same value from column B. What else could be wrong hard to say without sample file.