my datalist to fill in the columns automatically,

%3CLINGO-SUB%20id%3D%22lingo-sub-1624844%22%20slang%3D%22en-US%22%3Emy%20datalist%20to%20fill%20in%20the%20columns%20automatically%2C%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1624844%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20friends%2C%20could%20you%20help%20me%2C%20I%20need%20my%20data%20list%20when%20selecting%20an%20item%20to%20fill%20in%20other%20columns%20automatically%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20to%20use%20this%20formula%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3D%20IF%20(ISERROR%20(VLOOKUP%20(%5B%40%20Name%5D%3B%20'Store%20Assistants'!%20A24%3A%20%24%20F%20%24%201000%3B%202%3B%20FALSE))%3B%20%22%22%3B%20(VLOOKUP%20(%5B%40%20Name%5D%3B%20'Store%20Assistants'%20'!%20A24%3A%20%24%20B%20%24%201000%2C2%3B%20FALSE)))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eit%20just%20doesn't%20work%20when%20the%20column%20containing%20the%20list%20is%20empty.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1624844%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1625123%22%20slang%3D%22en-US%22%3ERe%3A%20my%20datalist%20to%20fill%20in%20the%20columns%20automatically%2C%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1625123%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F735858%22%20target%3D%22_blank%22%3E%40Gildo_Pinheiro%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20both%20VLOOKUP%20you%20selected%20column%202%2C%20thus%20they%20return%20exactly%20the%20same%20value%20from%20column%20B.%20What%20else%20could%20be%20wrong%20hard%20to%20say%20without%20sample%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional 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
Highlighted

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