Display filling one column based on another column
Solved
painghou
Posted messages
8
Status
Member
-
redaiwa Posted messages 370 Status Member -
redaiwa Posted messages 370 Status Member -
Hello,
On the "Defaut" tab, in column "I," there are codes displayed.
In another tab ("guide"), I have the correspondence of the codes (which is in column "B") to a text (which is in another column "C").
Is it possible to fill column "J" of "Defaut" with the correspondence from the "guide" tab, column "C"?
In short, I want that based on a code X appearing in column "I" of "Defaut," the corresponding message is displayed in column "J." The corresponding code is in column "B" of "guide," and the label from "C" is in "B."
Thank you in advance.
On the "Defaut" tab, in column "I," there are codes displayed.
In another tab ("guide"), I have the correspondence of the codes (which is in column "B") to a text (which is in another column "C").
Is it possible to fill column "J" of "Defaut" with the correspondence from the "guide" tab, column "C"?
In short, I want that based on a code X appearing in column "I" of "Defaut," the corresponding message is displayed in column "J." The corresponding code is in column "B" of "guide," and the label from "C" is in "B."
Thank you in advance.
2 answers
Salam painghou.
The formula that suits your case is VLOOKUP.
https://www.commentcamarche.net/faq/24720-fonction-recherchev-sur-excel#q=fonction+recherchev&cur=1&url=%2F
:)
--
"Repel evil with good, and suddenly he with whom you had enmity becomes like a warm friend" (Quran)
"He who does not know how to share is emotionally impaired". (Marc Levy)
The formula that suits your case is VLOOKUP.
https://www.commentcamarche.net/faq/24720-fonction-recherchev-sur-excel#q=fonction+recherchev&cur=1&url=%2F
:)
--
"Repel evil with good, and suddenly he with whom you had enmity becomes like a warm friend" (Quran)
"He who does not know how to share is emotionally impaired". (Marc Levy)