Search for multiple items in spreadsheet
Budget: $10 – $30 USD
Hello,
I need to search for multiple items that are listed in tab one, "Removals List" into tab two, "Overdue Initial Check" since there are thousands of names. If/once there is a match of the name in the "Overdue Initial Check" tab, I highlight the row in yellow and type "Remove" in column F. Can you please help me? Or at least a formula where this makes the searches quicker? Thanks!
I need to search for multiple items that are listed in tab one, "Removals List" into tab two, "Overdue Initial Check" since there are thousands of names. If/once there is a match of the name in the "Overdue Initial Check" tab, I highlight the row in yellow and type "Remove" in column F. Can you please help me? Or at least a formula where this makes the searches quicker? Thanks!