Error-104 Application-defined or object-defined error on vlookup command

[041418062]

Good day

I get the error - 104 when attempting a Vlookup. I'm using the same formula is pervious code and works.

I have 3 sheets (MSS DUMP, ALI DUMP, MCIQ), i have made sure that the VLOOKup is pointing correctly.

I also attempted to put a value like "343434343" instead of "MSS_DUMP_REFNUM" and works. but varible (MSS_DUMP_REFNUM) will be always be chaging, so it doesnt help it being a stale value.

a simple of code that would beretured from the Vlookup would be "4500053036", i even changes the type of varible from String to LONG and same issue.


//CODE//

Dim MSS_DUMP_REFNUM, ALI_DUMP_ESRD, MCIQ_REFNUM as String


On Error Resume Next


' what WORKS, goes into sheet "ALI DUMP" and searches for whats in "MSS_DUMP_REFNUM", if found store value in ALI_DUMP_ESRD
ALI_DUMP_ESRD = Application.WorksheetFunction.VLookup(MSS_DUMP_REFNUM, Worksheets("ALI Dump").Range("A2:L50000"), 3, False)

//some if statments//
...
...if ALI_DUMP_ESRD is NULL to input N/A...etc etc
//some if statments//

""DOES NOT WORK"
MCIQ_REFNUM = Application.WorksheetFunction.VLookup(MSS_DUMP_REFNUM, Worksheets("MCIQ").Range("A2:AL50000"), 1, False)


Thanks in advance

 

[JoeMo]

Is it possible that the value MSS_DUMP_REFNUM is not in the first column of Worksheets("MCIQ").Range("A2:AL50000")?

 

[041418062]

ya i checked that again and it's correct.

 

[JoeMo]

ya i checked that again and it's correct.

Have you checked to see if there are any extra spaces in the cell you think matches the value of the variable MSS_DUMP_REFNUM?

 

[041418062]

Yes, i just deleted the column and created a new one to make sure there nothing funcky with it and same issue.

 

[JoeMo]

Yes, i just deleted the column and created a new one to make sure there nothing funcky with it and same issue.

Did you enter the data in that column manually or by paste?

 

[041418062]

I created a new column and inputed 1.2.3.4.5.6. into 6 rows i made sure the old data was deleted

 

[041418062]

First off, Thanks Joe for your assistance.

I have corrected this issue. you did point me in the right direction. I have deleted the whole sheet and created a new one and seems like it work.
seems like it was a format issue all along.

Thanks again.

 

[JoeMo]

First off, Thanks Joe for your assistance.

I have corrected this issue. you did point me in the right direction. I have deleted the whole sheet and created a new one and seems like it work.
seems like it was a format issue all along.

Thanks again.

You are welcome - glad you got it sorted.