search a column
 

well, from what i got out of it the $ were to keep it from changing if
copy the cells down the sheet. but if i wanted to do it once and neve
copy it, i wouldnt use the $. So, for fun i took them away and i
doesnt work at all

--
DK
-----------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...fo&userid=1451
View this thread: http://www.excelforum.com/showthread.php?threadid=26139

search a column
 

You must have made a mistake. It should work with no problem in a single
cell without the $ sign.

=if(A2<"",vlookup(A2,D1:E200,2,False),"")

--
Regards,
Tom Ogilvy

"DKY" wrote in message
...

well, from what i got out of it the $ were to keep it from changing if i
copy the cells down the sheet. but if i wanted to do it once and never
copy it, i wouldnt use the $. So, for fun i took them away and it
doesnt work at all.


--
DKY
------------------------------------------------------------------------
DKY's Profile:
http://www.excelforum.com/member.php...o&userid=14515
View this thread: http://www.excelforum.com/showthread...hreadid=261398