search a column

[DKY]

Hey Tom,

Can you break this down for me? what exactly does it mean?
=if(A2<>"",vlookup(A2,$D$1:$E$200,2,False),"")

- what does the A2<>"" part mean, is that an action for if A2 has not
value?

- why the "$" in the $D$1:$E$200 part?

 

[Tom Ogilvy]

Yes, it makes the cell with the formula look blank until a value is entered
in A2. The $ in $D$1:$E$200 allows you to copy the formula down the column
without it changing. On the other hand, the A2 will change to A3, then A4,
etc which it what you want.