JLR123.xlsx | ||||
---|---|---|---|---|
A | B | |||
1 | Target | Match | ||
2 | Woof | Dog | ||
3 | Meow | Cat | ||
4 | Growl | Hippo | ||
5 | Naa | Goat | ||
Worksheet2 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D2:D6 | D2 | =IFERROR(INDEX(Worksheet2!A:A,MATCH(B2,Worksheet2!B:B,0)),"") |
JLR123.xlsx | ||||
---|---|---|---|---|
A | B | |||
1 | Target | Match | ||
2 | Woof | Dog | ||
3 | Meow | Cat | ||
4 | Growl | Hippo | ||
5 | Naa | Goat | ||
Worksheet 2 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D2:D6 | D2 | =IFERROR(INDEX('Worksheet 2'!A:A,MATCH(B2,'Worksheet 2'!B:B,0)),"") |