Compare and copy data from one column to another [Solved/Closed]
VBLearner3
Posts Monday November 19, 2012Registration date
November 20, 2012
Last seen
-
Nov 19, 2012 at 10:52 AM - Latest reply: Zohaib R2421
Posts Sunday September 23, 2012Registration date
July 16, 2018
Last seen
- Nov 20, 2012 at 05:04 PM
I'm trying to compare column A in Sheet 1 with column A in Sheet 2, then copy corresponding values in column N from sheet 1 to column N in Sheet 2 (where the column A values match). Also, the values in Column A Sheet 1 might not be in the same order or sequence as the values in Column A Sheet 2.
Use the below mentioned formula in column N of Sheet2:
=VLOOKUP(A2,Sheet1!A2:N8,14,0)
You must replace Sheet1!A2:N8 with your range of data in Sheet1. You can see that Name 01 and Name02 is common in both the sheets so a value is present in column N of sheet2.
I tried using the formula you mentioned and modified the range value and the sheet name according to the data I have and still it's not working. I am getting the error #Name. Here's what I used: =VLOOKUP(A2,All Requirements!A2:N7677,14,0).
