my datalist to fill in the columns automatically,

Copper Contributor

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.

1 Reply

@Gildo_Pinheiro 

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.