wat i nee is top get a formula to look for date then name and give me the aswer from cell c2 on sheet 1 and palce this on sheet 2 sheet 1 is populated by a excel form i have designed
wat i nee is top get a formula to look for date then name and give me the aswer from cell c2 on sheet 1 and palce this on sheet 2 sheet 1 is populated by a excel form i have designed
Last edited by NBVC; 01-09-2009 at 05:12 PM.
Try something like:
Please Login or Register to view this content.
confirmed with CTRL+SHIFT+ENTER not just ENTER. You will see { } brackets appear around the formula.. then copy it across.
Note: You will need to adjust ranges to suit your entire table... and probably you will need to replace "Paul" with a cell reference containing the name.... so that you can change that input cell and not every instance of the formula.
If you enter the names in a column, then you can copy down the formula and it will adjust for the entered name..
Reconfirm the formula with the CSE keys after any changes before copying it.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
sorry dont know how to mark as solved and many thanks for the answer
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks