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 Up Sheet'.
An easier example of what I want to do is if you have football squares and you enter your name in a cell (one of the squares) on a spread sheet it returns the value of the corresponding number in that row from the far left column (Could return value from the right column as in a Vlookup formula if needed) in a different worksheet. Ideally I would love to also have it identify the top scores too. So in other words if I put my name in the middle of the random boxes (Squares/Cells) the other worksheet will show me my two numbers. The number at the top of the column I am in and the number to the left of the row I am in. This would be so cool for what I am doing as well as a cool formula for all future Football Squares Pools.
Hope that all makes sense.
Larry Cochran
<!-- / message -->
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 Up Sheet'.
An easier example of what I want to do is if you have football squares and you enter your name in a cell (one of the squares) on a spread sheet it returns the value of the corresponding number in that row from the far left column (Could return value from the right column as in a Vlookup formula if needed) in a different worksheet. Ideally I would love to also have it identify the top scores too. So in other words if I put my name in the middle of the random boxes (Squares/Cells) the other worksheet will show me my two numbers. The number at the top of the column I am in and the number to the left of the row I am in. This would be so cool for what I am doing as well as a cool formula for all future Football Squares Pools.
Hope that all makes sense.
Larry Cochran
<!-- / message -->