Lookup???

[NirOrtal]

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

 

[T. Valko]

Try something like this:

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

Copy down as needed.

 

[Jacob Skaria]

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