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.
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.