If you dragged the formula across the columns, then that first reference may
have changed:

=VLOOKUP(D471,MYLOOKUP,2,0)

did it change to something like:
=VLOOKUP(E471,MYLOOKUP,3,0)

You may want to do:
=vlookup($d471,mylookup2,2,0)

Then when you drag it across the columns, the column (in $d471) will not change.



roger_home wrote:
>
> I did what Dave Peterson said and it works fine for the 1st column, on
> the 2nd, 3rd, etc. I get n/a. (I was carefull to make a new VLOOKUP
> range and name it different.) Any ideas??
>
> --
> roger_home
> ------------------------------------------------------------------------
> roger_home's Profile: http://www.excelforum.com/member.php...o&userid=16434
> View this thread: http://www.excelforum.com/showthread...hreadid=516529

--

Dave Peterson