return a value

G'Day Excel people's, Background: What I have is an Excel sheet set up as a monthly schedule. Currently a file number is allocated to each job manually in a separate Excel workbook and then this is manually inputted onto the monthly schedule. This is a cumbersome timely process (and who here...

Sub TrackChanges() Dim editWord As String editWord = GetWord() End Sub Function GetWord() As String Dim wordStr As String wordStr = "What am I doing wrong?" End Function In VB.Net, functions are used to process something and return some value. You actually have to...

Hi, I want a formula that will return with the value of cell A1 but if cell A1 is blank, then it will take only the value of C1. I tried using this formula - not working right. Thanks ;)

I am pretty sure this is an easy question but I have no idea how to create the formula that I need. Please help! I have an excel workbook that has multiple inventory items on it. Certain items are being marked to "keep", "sale", or "scrap". At the top of the sheet I have a total row. I need...

Hello all, I need help with a formula for Excel 2010. I have a spreadsheet that is sent to me daily that grows in row length daily by 5-10 rows (varies). I need a formula on a seperate tab "Pivot1" to look to "End User" and go in Column A:A and look for a date that I list on "Pivot1" if you...

This is my problem now: I am using Office 2003 I am trying to use a formula (Maybe a VLOOKUP not sure if it's the best choice) so when a name is entered on the 'Sign Up Sheet' it returns a date that corresponds to where the name was entered and returns the date in the first column of the 'Sign...

This is my problem now: I am using Office 2003 I am trying to use a formula (Maybe a VLOOKUP not sure if it's the best choice) so when a name is entered on the 'Sign Up Sheet' it returns a date that corresponds to where the name was entered and returns the date in the first column of the 'Sign...