how do i match the corresponding cell values between different sheets?-CodePudding

Home > Blockchain > how do i match the corresponding cell values between different sheets?

how do i match the corresponding cell values between different sheets?

Time：07-01

How do i auto update sheet 2 column B such that when corresponding values are added in column B of sheet 1.

CodePudding user response：

Try this in cell 'Sheet2'!B2:

=IFERROR(ARRAYFORMULA(VLOOKUP(A2:A,Sheet1!A2:B,2,FALSE)),"")