Application.WorksheetFunction.VLookup error 1004

[CrashOD]

Dim FinalResult As Variant, Table_Range As Range, LookupValue As Range
Set Table_Range = Sheets("Requestor").Range("A:B")
Set LookupValue = Sheets("Tax Cert Bill").Range("B12")
' original code ' FinalResult = Application.WorksheetFunction.VLookup(LookupValue, Table_Range, 2, False)
' updated code ' FinalResult = Application.WorksheetFunction.VLookup([LookupValue], [Table_Range], 2, False)
On Error Resume Next

i tried both the original worked but when there is no match it give error 1004 i tried the on error resume next but still stops there. I also read

VBA-Vlookup problem 'error 1004'

Private Sub GetRoomPrice_Click() Set PriceTable = Range("Prices") If RoomNR.Text = "" Then GoTo e RoomPrice = WorksheetFunction.VLookup(RoomNR.Text, PriceTable, 2)e: End Sub when i use this code in the button that is on my form i get the following error.. " Run-time error...

www.mrexcel.com

so tried with updated code when the On Error Resume Next did not work.

error

code being ran on this sheet

Looking name up on requestor page

any help would be great. thanks.

 

[Joe4]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

If you go into the VB Editor, and under the "Tools" menu select "References" an d take a look at the selected references/libraries, do you at least have these four selected?

(note they might be a different version number).

If not, select those four and see if that resolved your error.

 

[CrashOD]

updated profile thing as asked. thanks for letting me know about that.
office 2016 32bit
office 2021 i don't remember if 32bit or 64bit (computer at home i have 64bit os and dont off hand remember what version i installed)

they were already selected.

 

[Joe4]

OK, then it is probably not finding a match.

Note that your:

On Error Resume Next

line would have to come BEFORE your VLOOKUP calculation lines in order for that to work, as Andrew showed in the link you provided (you have it after - it is too late at that point!).

 

[CrashOD]

OK, then it is probably not finding a match.

Note that your:

On Error Resume Next

line would have to come BEFORE your VLOOKUP calculation lines in order for that to work, as Andrew showed in the link you provided (you have it after - it is too late at that point!).

thanks i put it before and working great thanks.

 

[Joe4]

You are welcome.

I would recommend that after those VLOOKUP lines of code that you then add the line:

On Error GoTo 0

Otherwise, any others that your code may incur will be totally ignored. which you probably don't want (you may get a lot of unintended consequences otherwise and/or have lots of issues with code debugging).

 

[CrashOD]

On Error Resume Next
FinalResult = Application.WorksheetFunction.VLookup(LookupValue, Table_Range, 2, False)
On Error GoTo 0

thanks i added it. only on in macro on sheets it self i use
=INDEX('[RLE_County Local 2022.xls]Real Estate'!$A:$P,MATCH(C12,'[RLE_County Local 2022.xls]Real Estate'!$P:$P,0),8)

to pull info from 4 different books so different code for were to match to. i am almost dont with what i need for this. im sure someone could probally look at code and clean it up since i take bits and pieces on code to use to make my vba script.

one last issue im waiting on answer for and i think my code maybe done other then getting it to open gmail email to add attachment, excedera is
IE printscreen Call keybd_event(VK_SNAPSHOT, 1, 0, 0) turning NumLock off

thanks so much for your help. !!!!!!!!!!