SOLVED

formul

%3CLINGO-SUB%20id%3D%22lingo-sub-3096980%22%20slang%3D%22en-US%22%3Eformul%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3096980%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20excel%20sheet%20%3DVLOOKUP(A3%7CDROP!%24A%242%3A%24CC%2474%7C2%7C0)%20formula%20instead%20of%20%2C%20its%20asking%20put%26nbsp%3B%20%7C%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DVLOOKUP(A3%7CDROP!%24A%242%3A%24CC%2474%7C2%7C0)%20this%20is%20getting%20in%20my%20sheet%3C%2FP%3E%3CP%3E%3DVLOOKUP(A3%2CDROP!%24A%242%3A%24CC%2474%2C2%2C0)%20for%20others%20formula%20showing%20like%20this%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3096980%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3102880%22%20slang%3D%22en-US%22%3ERe%3A%20formul%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3102880%22%20slang%3D%22en-US%22%3EThank%20you%20so%20much%3C%2FLINGO-BODY%3E
New Contributor

In excel sheet =VLOOKUP(A3|DROP!$A$2:$CC$74|2|0) formula instead of , its asking put  |    

 

=VLOOKUP(A3|DROP!$A$2:$CC$74|2|0) this is getting in my sheet

=VLOOKUP(A3,DROP!$A$2:$CC$74,2,0) for others formula showing like this

2 Replies
best response confirmed by Sergei Baklan (MVP)
Solution

@manumiyar 

Assuming that you are on Windows: Excel uses the so-called list separator between arguments of a function.

In most countries that use a point as decimal separator, the list separator is a comma:

=VLOOKUP(A3,DROP!$A$2:$CC$74,2,0)

In most countries that use a comma as decimal separator, the list separator is a semicolon:

=VLOOKUP(A3;DROP!$A$2:$CC$74;2;0)

But it is possible to specify a different list separator in Control Panel >Change date, time or number formats > Additional settings...:

S1116.png

If a | has been entered in the List separator box there, you should use | in Excel formulas.

Thank you so much