SOLVED

formul

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