vlookup help

[cthurston]

I have a range of names in Table 1 Column B, I would like to match that to names in Column J. If those names match I need the information from Column K to populate in Column C.

Hope this makes sense, please help.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IFNA(INDEX($K$2:$K$100,MATCH(B2,$J$2:$J$100,0)),"")