VLookUp Value From One Sheet To Another Sheet

[Ryan_Bernal]

Hi Guys,
I here again.
Just want to know the best solution for this.
I have 2 sheets. The sheet 1 is checksheet. sheet2 is database.
On sheet1 (checksheet). I want to populate the codes (code column) of every item value that i input(item column).
For instance,
If i type A it automatically include the corresponding code items on the code columns.
Hope someone will help me regarding on this.
Thanks in advance.


https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA (https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA)

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA (https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA)

[Ryan_Bernal]

I've populate the item using index and match function but unfortunately the the other codes that belong to the other items also included.
This is the update. (all formatted in yellow should not be included).
Any other solutions for this??? :pray:
Any help is highly appreciated..


https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA (https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA)

[Ryan_Bernal]

Sorry guys. Ive found solution to my problem into this forum.
display in columns of the values of merge cell (look up value) (http://www.ozgrid.com/forum/showthread.php?t=177110).
I really need to solve this.
BTW, thanks....


https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA (https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA)

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA (https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA)