81+ How To Find Duplicate In Google Sheets New. In the vlookup dialog box, select lookup value and then type in the value that you want to look for. Assume cell h2 contain the search key “car”. How to Find and Remove Duplicates in Google Sheets from www.alphr.com Column b will be sort and duplicates …