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

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

In Col A cell A1 try the below formula and copy down as required

=IF(ISNA(VLOOKUP(B1,J:K,2,0)),"",VLOOKUP(B1,J:K,2, 0))

If this post helps click Yes
---------------
Jacob Skaria


"NirOrtal" wrote:

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