VBA vlookup to last row error

**maym** · 02-22-2020, 10:15 PM

I am hoping this is fairly simple, but I have never used the last row in a vlookup before. I have the below code:

Please Login or Register  to view this content.

but it results in a 'Application-defined or object-defined error'

When I hover over lRow1 it shows the row number, so I know this is defined correctly. Can anyone assist with this?

**scottiex** · 02-22-2020, 11:13 PM

you are mixing RC[-1] format with P$11 format

if you want to use RC format use .FormulaR1C1 not .Formula and use it for the whole formula

**maym** · 02-22-2020, 11:34 PM

thanks Scottie, that works

VBA vlookup to last row error

LinkBack

Thread Tools

Rate This Thread

Display

VBA vlookup to last row error

Re: VBA vlookup to last row error

Re: VBA vlookup to last row error

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA Error 13 Mismatch Error on Vlookup

[SOLVED] Vlookup Error - unable to get the vlookup property of the worksheetfunction class

Error thrown by VLookup when not an error

[SOLVED] application vlookup error runtime error 1004, unable to get the vlookup property of the.."

Concatenate error across 2 worksheets with vlookup error

How to error trap a vlookup that returns an error or #N/A

[SOLVED] lookup - if(is error(vlookup and error messages meanings

Bookmarks

Bookmarks

Posting Permissions