In column D1 and copy down:

=IF(ISNA(MATCH(B1,$A$1:$A$9,0)),"",C1)

If column B matches list in A, C value is placed in D

Extended range A as required (dynamic list if it varies greatly)

Is this what you want?

"sam" wrote:

In column A there are 9 numbers. They are not consecutive. In Column B there
are 5,000 numbers and the nine numbers from Column A will occur often thruout
the list.

In Column C there are 5,000 numbers that give me info about the B column
value of the same line.

How do I extract the C column value to column D of the same line?

Because those Column C values will all be different for each of the nine
numbers of Column A , a vlookup table cant be used.

Because they are not consecutive, sort wont help me.

I dont want to do something manually, because those 9 numbers of column A
could easily be 800 numbers, with 50,000 numbers in Cols B and C.

Ive been using an IF(OR formula, but that only allows 30 arguments.

I am stumped, and Im dyin to know what you gurus suggest€¦

MUCH Thanks,

sam