I have a spreadsheet and i want to compare 2 columns (A and D) A has 40000 rows and D has 38 rows.
I want to compare D to A and if the the value in D is found in column A then show a corrosponding look value (which is in columb B) in column H, if there is not match then show false.
A B C H
1 111 2 133
2 133 14 False
Whats the best way of doing that?