Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
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) |