Google spreadsheet : check if similar value and then copy row

user_1662884 0
Viewed 31

I have two columns containing names (A and B) and a third one with positions (C). At the moment C positions are matching B column. I want C positions to match A column in column D.

A B C D (expected values)
Apples Apples Fridge Fridge
Oranges Bananas Kitchen Fridge
Oranges Fridge
vlookup google-sheets-formula similarity google-sheets duplicates
1 Answers

try:

=INDEX(IFNA(VLOOKUP(A1:A; B1:C; 2; 0)))

enter image description here

user_56326290
Related