Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to search in one column, and replace in the other column if fo | Excel Discussion (Misc queries) | |||
Search a column for values, return a value from adj column | Excel Worksheet Functions | |||
LookUp Function with Two Column Search Returning One Column Value | Excel Worksheet Functions | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
Search one column and return value from next column | Excel Discussion (Misc queries) |