Excel XP question working with array's

[J.Heegsma]

Hello Guys/Girls,

I have the following problem.

I have one main-list (Row A and B) with all member numbers. Also I got a
list (Row K and L) which contains a second List with financial information
and a part of the numbers of the members-list.

I would like to combine this. Is there een option, like the if-function,
which could check the mainlist with the second-list and if there has been
found a match, the financial information put in Colum C behind the right
member number?.

Greetings from the Netherlands,
Johan Heegsma

 

[Frank Kabel]

Hi
fi column A and column K contain the member numbers and you want the
information from column L in column C enter the following in C1:
=IF(ISNA(MATCH(A1,$K$1:$K$1000,0)),"",VLOOKUP(A1,$K$1:$L$1000,2,0))
and copy down