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

search a column
 

Yes, it makes the cell with the formula look blank until a value is entered
in A2. The $ in $D$1:$E$200 allows you to copy the formula down the column
without it changing. On the other hand, the A2 will change to A3, then A4,
etc which it what you want.

--
Regards,
Tom Ogilvy

"DKY" wrote in message
...

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