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)
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)
- 'A2' means Your unique address that match with another data sheet
- 'Contact Data'!A:C means Your another sheet data that all data.
- '2' means which column data you want to get.
- When You will run this formula that it will ask what sheet select by you that time select data sheet that all data imported.