I have two sheets in excel both having common value of Loan Id and i have one extra column in first sheet "Assignee name". I need the same assignee name value for all row by referring Loan id.
我有两张excel,两张都有Loan Id的共同值,我在第一张“受让人姓名”中有一个额外的列。通过引用Loan id,我需要为所有行设置相同的受理人名称值。
1 个解决方案
#1
0
You can use vlookup for this
您可以使用vlookup
`=VLOOKUP(A2,Sheet1!A:B,2,FALSE)`
Where Sheet1 has both loanId and Assignee name. Loan IDs in column A and Assignee name in Column B
Sheet1同时包含loanId和Assignee名称。 A列中的贷款ID和B列中的受让人名称
#1
0
You can use vlookup for this
您可以使用vlookup
`=VLOOKUP(A2,Sheet1!A:B,2,FALSE)`
Where Sheet1 has both loanId and Assignee name. Loan IDs in column A and Assignee name in Column B
Sheet1同时包含loanId和Assignee名称。 A列中的贷款ID和B列中的受让人名称