Try something like this:

=IF(COUNTIF(J$2:J$10,B2),VLOOKUP(B2,J$2:K$10,2,0), "")

Copy down as needed.

--
Biff
Microsoft Excel MVP


"NirOrtal" wrote in message
...
hi

i have Excel 2007.

the scenario is:
in column B there are numbers,
in column J i have some of the numbers from column B,
in column K i have the information the related to column J,

i need a formula that find the exact number from column B & J and copy the
info from column K to column A

i lookup function working here?

thank you