Hi,Try:
Book1
A B C 1 2 Lookup 7 3 Return G 4 5 6 1 6 11 7 2 7 12 8 3 8 13 9 4 9 14 10 5 10 15 11 12 A F K 13 B G L 14 C H M 15 D I N 16 E J O Sheet8
Cell Formulas Range Formula B3 B3 =CONCAT(IF(B2=A6:C10,A12:C16,""))
Oddly enough, I'm not getting that on my end.Hi,
Thx for the reply and help. But it is not what i am looking for. It gives me the right answer, but it places it in some kind of window. So when i change the lookup value the answer jumps to another place in the windows.
It needs to stay in the same cell.
Thx that made it work. Made a mistake in the translation to te dutch code.Oddly enough, I'm not getting that on my end.
Did your formula include the "Concat" portion as well? That should prevent the additional window from showing up.
View attachment 104397
Thx for your help.Coyotex3, I think you figured it out by now. The IF compares B2 with each value in the first table, and if it matches, returns the corresponding value in the second table, otherwise a "". Then the CONCAT puts them all together, and only the desired value will be left. Thanks for the assist.
Otchoo, looks like you got it figured out. Glad we could help.