When using VLOOKUP, there are some common limitations that data analysts should be aware of. Identify these limitations. Select all that apply.
1) VLOOKUP only works with data in the leftmost column of the table array
2) VLOOKUP cannot search for values in columns to the right of the lookup column
3) VLOOKUP only returns the first matching value in the lookup column
4) VLOOKUP requires the lookup column to be sorted in ascending order