I have two worksheets in google sheets.
In Sheet1 I have a list of items along with a type column.
In Sheet2 I have a list of unique items taken from sheet1, I manually enter the type for each item over here.
What I want is to populate the type column in Sheet1 automatically from Sheet2 based on item name. Something like
=IF(Sheet1!B2 = Sheet2!A1, Sheet2!B1)
but this formula only checks a single value and not a range of values
Sheet1:
Sheet2: