The error when write formula in excel

Help Studio
1

when use the below value for the “what to write”, there is error like this. Can anyone help solve it?
= value(ISNUMBER(MATCH(K"& CurrentRow & “,” & MatchList.Sheet(“客商信息”).Range(“A:A”) & " ,0)))

image
image1428×477 30.3 KB

2

@jackie.yue

Please check this

"=value(ISNUMBER(MATCH(K" + CurrentRow + "," + MatchList.Sheet("客商信息").Range("A:A") + " ,0)))"

I hope these two are variables - CurrentRow ,MatchList.Sheet(“客商信息”).Range(“A:A”)

cheers

3

still occured error like this：

image
image1420×477 32.7 KB

4

@jackie.yue

You missed the starting and ending double quotes

cheers

5

BelwBelow is the waring with the two double quotes.

image
image1407×342 15.9 KB

6

@jackie.yue

currentrow is not a string/?

where are you getting it …what does it hold?

it says that the type is CurrentRowQuickHandler…it should ideally be string containign a integer value for indicating row number I believe

I guess its the currentrow from the for each row in excel …if you need currentrow index then use currentIndex.ToString and generally it starts from zero so use like this (currentIndex+2).ToString(assuming data starts from row 2 in excel)

cheers

7

Thanks Anil,
The currentrow is from the for each row in excel. I revised as below, but there is still error.
“=value(ISNUMBER(MATCH(K” + CurrentIndex.ToString & “,” + MatchList.Sheet(“客商信息”).Range(“A:A”) +" ,0)))"

image
image1373×298 15.1 KB

8

@jackie.yue

Now MatchList.Sheet("Name").Range("A:A") will return a Rangevalue type variable …I guess you need to directly give "A:A" without anything else…if its a different sheet then give "Sheetname!A:A"

final formula : "=value(ISNUMBER(MATCH(K" + CurrentIndex.ToString + ",客商信息!A:A,0)))"

or "=value(ISNUMBER(MATCH(K" + CurrentIndex.ToString + ",A:A,0)))"

cheers

9

Thanks Anil, the final expression is correct.
“=value(ISNUMBER(MATCH(K” + CurrentIndex.ToString+ “,A:A” +" ,0)))"

1 Like
10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.