Vlookup not working with table view

[sharky12345]

I'm trying to write a Vlookup worksheet function to get the values from a worksheet that's formatted as Table View but I keep getting a run-time error 1004. If I use this on a normal worksheet it works fine though. Can anyone help me understand why please?

LastRow = Sheet2.Range("A65536").End(xlUp).Row
LastCRRow = Sheet4.Range("A65536").End(xlUp).Row

LookupRng = Sheet4.Range("A2:J" & LastCRRow)

For Each Cell In Sheet2.Range("I2:I" & LastRow)

Cell = WorksheetFunction.VLookup(Cell, LookupRng, 4, False)

 

[sharky12345]

Further - I realise there is in error in what I've posted because the value searched for should be cell.offset(0, -8), and not cell

 

[Alex Blakenburg]

Can you start with this and then see what we still need to address:

Set LookupRng = Sheet4.Range("A2:J" & LastCRRow)