validation hi, I have a workbook with 2 sheets. In one sheet I have a calender and other sheet just list of names. what i want to do is: In the calender sheet if i have a name under a date and when i enter that date beside that name in the sheet of name list, i want to have a message saying that he/she is on vacation. ... 5 May 2010 16:03 How to freeze one column vertically, one horizontal in same sp That was what I took her question to mean she wanted. Sorry if she didn't want this. "Billns" wrote: On 5/4/2010 3:08 PM, Nadine wrote: What cell is below the row you want frozen and to the right of the column you want frozen. Find that intersection cell and place your cursor in it. Then go ... 5 May 2010 16:03 Calculate next workday after adding calendar days to date in cell I want to add 100 calendar days to a date in a cell and when that date falls on a weekend or holiday the formula will return the next workday vs. returning a weekend date. I tried the workday function but it counted 100 workdays not calendar days. Thanks in advance ... 5 May 2010 17:10 Convert text entered as minutes/seconds to minutes I have several entries (formatted as text) for example, :31, 1:04, 4:53, 23:34. These numbers indicate minutes and seconds (31 seconds, 1 hour 4 seconds, etc). What formula can I use to convert these entries into seconds? ... 6 May 2010 00:56 how to remove #n/a error in excel vlookup b/c value is not fou Thank you- this was great!! "T. Valko" wrote: Try one of these: Returns a blank: =IF(ISNA(VLOOKUP(.....)),"",VLOOKUP(.....)) Returns a 0: =IF(ISNA(VLOOKUP(.....)),0,VLOOKUP(.....)) -- Biff Microsoft Excel MVP "B. Franklin Saunders"