1 Attachment(s)
VLookUp Value From One Sheet To Another Sheet
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
1 Attachment(s)
update:look UP values?? using index and match function.
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