| 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 |
| 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) | |||
![DKY[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
