Hi guys,
I'm new to excel at school, so I would love to ask you for little help. I have to pull all correct numbers from second sheet into first sheet at right column. I've tried to write a formula to solve the problem, the answer is not correct. The main purpose of the formula is compare the value from TASK sheet into first column in DB sheet and if find matches to continue matching with next cells on the row. The advanced level is to write all correct matches into 1 cell, delimited by comma. I will appreciate any help. thanks in advance.
Kind regards,
Michael.
school_task.xlsx
Bookmarks