VLOOKUP Function is used to?

1. Find corresponding value of a reference cell in the same row and different column of a list or table
2. Copy data in multiple sheets within the same Excel workbook
3. Highlight duplicate values within a table
4. None of the above

Please refrain from posting this type of useless questions.
Thank you
Thread closed