need help on a formula to compare two columns.

Copper Contributor

I'm trying to compare the columns of two sheets with unique content, so that if the data in columnA on sheet1 matches the data in the columnA on sheet2,  excel will return the data in columnB on sheet1 to column B on sheet2

 

Trying to avoid using a vlookup

2 Replies

@bizzle4401 

In B2 on Sheet2:

 

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

 

Fill down.

@bizzle4401 

Perhaps like

=XLOOKUP(A1:A500,Sheet2!A1:A500,Sheet2!B1:B500,"")