Thread: How to Match and fill two lists of unequal length

Hello,

I have a reference list which contains codes and their corresponding txt
and another list that contains just the codes but in multiples

is there a way to automatically match the two lists and fill the blanks in the longer list with corresponding txt,

e.g.

List 1-reference
A1 B1
11 Xray
12 CT-Head
13 Foley

List 2
A1
11
11
11
11
12
12
13
13

so that list two fills with the txt description based on list 1

Put this in B1 of the second sheet:

=IF(ISNA(MATCH(A1,'List 2'!A:A,0)),"",VLOOKUP(A1,'List 2'!A:B,2,0))

then copy down as far as you need to.

Hope this helps.

Pete

Originally Posted by Pete_UK

Put this in B1 of the second sheet:

=IF(ISNA(MATCH(A1,'List 2'!A:A,0)),"",VLOOKUP(A1,'List 2'!A:B,2,0))

then copy down as far as you need to.

Hope this helps.



Pete

hey thanks a lot, but one quick question, what is the "array" for the function?
I am a little confused as to the 'List2'! meaning

Thank you Art

Originally Posted by Pete_UK

Put this in B1 of the second sheet:

=IF(ISNA(MATCH(A1,'List 2'!A:A,0)),"",VLOOKUP(A1,'List 2'!A:B,2,0))

then copy down as far as you need to.

Hope this helps.



Pete

hey thanks a lot, but one quick question, what is the "array" for the function?
I am a little confused as to the 'List2'! meaning

Thank you Art

'List2'! means you are referencing the sheet named List2. Look along the bottom and you will see the name on the tab. An array is an arrangement of quantities in rows and columns, as in a matrix.

Sucess! thank you all