Used well, suddenly appeared this problem
When selecting the current sheet or other written scope of sheet, said an error parameters too little
As shown in figure

CodePudding user response:

Looking at should not ah, or even just tried to enter in 2003 is full Angle of commas, all seem to be automatically replaced with half Angle of English comma character, or XLSX file uploading to look at?

CodePudding user response:

reference 1/f, zara's reply:

watch should not ah, or even just tried to enter in 2003 is the Angle of a comma, all seem to be automatically replaced with half Angle of English comma character, or XLSX file uploading to look at?

As if can't upload attachments, the problem is especially strange, vlookup is used quite frequently, puzzling out this problem,

CodePudding user response:

Vlookup vlookuo need four parameters (target, query, need how many rows value, 0) 0 is precisely locate
=VLOOKUP (C3, C6: D10, 2, 0)