How to match the arrays cell values in Excel

[hileh]

Hi everyone,

Please see the enclosed file.
Section 1 is an array of some numbers, C6:G9.
Section 2 is a two column array of numbers and names, K6:L14.

How could a formula be written to compare the content of each cell within the C6:G9 to the list of K6:K14 and if a match, to return the name besides the match, to the range in Section 3.

For example it would compare F6 to list in section 2 and would return the name "James" in F18.
The sheet is not meant to make sense, but rather to learn how to get around.

Thank you,
Hielh

[protonLeah]

title changed.

[protonLeah]

NAMED RANGE "section_2" set for cells K5:L14
named range "transactions" set for K5:K14
In C18, down and across:

Please Login or Register  to view this content.

[hileh]

Thank you ProtonLeah

Your solution works perfect. But, with my apologies for not clearly stating it before, I meant to have one formula that would do the job without entering it to each cell in section 3.

Once again, thank you for your efforts and time your put into this.
Hileh.

[Glenn Kennedy]

Hi. One formula, same result. Is this what you wanted?

After posting this, I opened protonLeah's sheet, assuming that he'd misread the request. But no - it's a perfectly OK solution. Hileh - what you want cannot be achieved by a formula, I think.

[newdoverman]

If you don't like named ranges, the formula given becomes:

Please Login or Register  to view this content.

Fill across and down.