How to lookup article number in one table and display article name in other table

[louisbanens]

Hi There,

I want to lookup the ARTNR in ORDER TABLE in FRUIT TABLE and display FRUIT_NAME in ORDER_TABLE.

Any ideas how to do this?

---

ORDER TABLE

ARTNR NAME

173810 ???
140110 ???

---

FRUIT TABLE

CAT ARTNR FRUIT_NAME

CITRUS 173810 Sinaasappel
CITRUS 150100 Citroenen
FRUIT 140110 Ananas
FRUIT 140220 Avocado

[Wanderer]

@louisbanens

Any ideas how to do this?

VLOOKUP(Search criterion; Array; Index[; Sorted range lookup])
https://wiki.documentfoundation.org/Documentation/Calc_Functions/VLOOKUP
.
So you need something like
=VLOOKUP(A2; Fruit.$B$2:$C$100; 2; 0)
in B2 (instead of ???), when I assume your 173810 is in A2 and your “Fruit Table” is named Fruit