I'm trying to lookup a value on a spreadsheet within a table array using the VLOOKUP function in my vba code. I don't know how to write it correctly.

Here is the normal VLOOKUP formula with all the references:

```
=VLOOKUP(DATA!AN2,DATA!AA9:AF20,5,FALSE)

```