CODEWITHSUNDEEP
if-statementgoogle-sheetsgoogle-sheets-formulamatchvlookup
icecream sugar black
icecream sugar black

Reputation: 63

A formula that finds the value in range 1 in range 2 and returns the value in another column at that row position

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

enter image description here

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!

Upvotes: 1

Views: 55

Answers (1)

player0
player0

Reputation: 1

use:

=INDEX(IFNA(VLOOKUP(AF5:AF; AH:AI; 2; )))

Upvotes: 2

Related Questions