Thread: search a column
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DKY[_4_] DKY[_4_] is offline
external usenet poster
 
Posts: 1
Default search a column


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?


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