Hello quick question i think. I'm tring to return column F in to the corresponding value of B in C from table F:I. It has to match a value in one of the three columns and then return the text in F. I've tried Index and Match and VLookup, but with no succes.
Does someone know the trick?
Does someone know the trick?
Map2 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | A | 2 | LOC.1 | 1 | 2 | 3 | |||||
2 | B | 4 | LOC.2 | 4 | 5 | 6 | |||||
3 | C | 1 | LOC.3 | 7 | 8 | 9 | |||||
4 | D | 6 | LOC.4 | 10 | 11 | 12 | |||||
5 | E | 8 | |||||||||
6 | F | 4 | |||||||||
Blad1 |