If you use

B1: =VLOOKUP(A1,C:D, 2, FALSE)

and copy down, it will use the entire C:D range as a lookup range.

You can't use a formula to fill in values in other cell(s). For that
you'd need a macro.

and In article ,
detlghtpd wrote:

can i make it look up and work the entire a, b,c,d columns