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