Question

excel表中A列和B列对应，C列和D列对应如何比较A列和C列的值，并且把对应D列的值赋给B列

例如
A B C D
1 2 a
2 3 b
3 5 c
4 1 d
5 4 e
6
结果
A B C D
1 d 2 a
2 a 3 b
3 b 5 c
4 e 1 d
5 c 4 e
6 -1
A列比C列多出的项目则对应B列赋值-1

Answer 1

B1输入公式
=iferror(vlookup(a1,c:d,2,0),-1)
公式下拉完成

Answer 2

char A[6] = {1,2,3,4,5,6};
char B[6] = {-1,-1,-1,-1,-1,-1};
char C[5] = {2,3,5,1,4};
char D[5] = {'a','b','c','d','e'};
int i=0;
for(i=0; i<5; i++)
{
B[c[i]] = D[i];
}

printf("A B C D\n");
for(i=0; i<6; i++)
{
B[c[i]] = D[i];
printf("%d %c ", A[i], B[i]);
if(i<5)
printf("%d %c ", C[i], D[i]);
printf("\n");
}