I have two worksheets. The following are the conditions based on which Values from Sheet 2 need to be copied over to Sheet 1.
In Sheet 2: We have Column A, Column N, Column R
Sheet 2 has multiple values for each instance of a Pipe
A is the primary value(InstanceID), along with Columns N or R (Value can be present in either N or R, or both) (datatype of N and R are double)
N and R are never present on the same row together.
On Sheet 2, If N is present, then Column A+Column N values need to be matched with values on Sheet 1.
On Sheet 2, If R is present, then Column A+Column R values need to be matched with values on Sheet 1.
If N and R are empty for a row, then skip that row in Sheet 2
Next match Sheet2's column A with Sheet1's column A, then Match N or R value of sheet 2 with Sheet1's Column D
Once both the values are matched, copy values Column Z, Column AA, Column AB from Sheet 2 to the columns K,L,M of Sheet 1
This needs to be done for every row in Sheet2.
Can someone help me out!
In Sheet 2: We have Column A, Column N, Column R
Sheet 2 has multiple values for each instance of a Pipe
A is the primary value(InstanceID), along with Columns N or R (Value can be present in either N or R, or both) (datatype of N and R are double)
N and R are never present on the same row together.
On Sheet 2, If N is present, then Column A+Column N values need to be matched with values on Sheet 1.
On Sheet 2, If R is present, then Column A+Column R values need to be matched with values on Sheet 1.
If N and R are empty for a row, then skip that row in Sheet 2
Next match Sheet2's column A with Sheet1's column A, then Match N or R value of sheet 2 with Sheet1's Column D
Once both the values are matched, copy values Column Z, Column AA, Column AB from Sheet 2 to the columns K,L,M of Sheet 1
This needs to be done for every row in Sheet2.
Can someone help me out!
