View Single Post
  #4   Report Post  
EMarre
 
Posts: n/a
Default Copy VLOOKUP Formula

Dave O,

Thanks for your help. It works !

"Dave O" wrote:

The formula in B1 would be VLOOKUP(A1, etc). Since you're going to
copy this down a column, here's a tip: when you define the look-up
range in the VLOOKUP use reference anchors (for instance, $D$1:$E$10)
to lock the range.