Autoincrement the VLOOKUP column index in Excel - Super User

Why automatically increase value in vlookup?

How to solve automatically increase value in vlookup?

It's best solution I found. You can easily resolve by below formula.


=VLOOKUP(A2,'Contact Data'!A:C,2,FALSE)

1. 'A2' means Your unique address that match with another data sheet
2. 'Contact Data'!A:C means Your another sheet data that all data.
3. '2' means which column data you want to get.
4. When You will run this formula that it will ask what sheet select by you that time select data sheet that all data imported.