I have the following vlookup and it works fine, however to get this to work in other sheets I will need to have the R25 to be a last row that contains values, rather than a hard coded Row 25. Can this be done? Basically I need to pull the range using last row from the external spreadsheet rather than hard coding the R value in the vlookup.
"=VLOOKUP(RC[-6]," & Wb & "Product Receipt'!R2C1:R25C18,16,FALSE)"
Obviously the Wb is a variable, this variable contains the path and filename that the data come from in the vlookup.
the starting point of the range will always be constant, but the end row will always be different, hence the need for this functionality.
Any help would be great, thank you.
Bookmarks