| data1 | data2 | data2 | rusult |
|---|---|---|---|
| a | a | apple | apple |
| c | b | banna | kiwi |
| b | c | kiwi | banna |
| c | kiwi | ||
| a | apple | ||
| a | apple | ||
| b | banna | ||
| c | kiwi |
Find the first value 'a' in data2.
Using the found row position as the index, find the value of the second column of data2.
Record in result.
Repeat process.
I want to make this work as a formula!
CodePudding user response：
use:
=INDEX(IFNA(VLOOKUP(AF5:AF; AH:AI; 2; )))